[ciapug] ORACLE issue (from PHP)

Lathrop Preston ciapug@cialug.org
Fri, 30 May 2003 13:41:06 -0500


Has anyone seen this issue

connecting from PHP to and ORACLE 8

and getting this message:
	ORA-01012: not logged on in Unknown on 0

not every time.

many times associcated with one of the later DB hits on the page.

Example

SELECT FOR USER RECORD
IF EXIST
	UPDATE RECORD
ELSE
	CREATE RECORD
ENDIF

the SELECT works and it then errors on UPDATE

again it is completely random and can hit on any QUERY in a page

oh and I create 1 DB handle in the begining of each page and that gets 
used by all...

Lathrop
CROSSPOSTED TO CIALUG/CIAPUG