[ciapug] ORACLE issue (from PHP)

[Lathrop Preston]

It appears that at least part of the problem can be solved by changing 
from a Connect() to a PConnect()

Thanks DC

I have no idea why I was using a Connect() to begin with...

Lathrop

Lathrop Preston wrote:
> 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
> 
> _______________________________________________
> ciapug mailing list
> ciapug@cialug.org
> http://cialug.org/mailman/listinfo/ciapug