| OCI and Oracle SESSIONS [message #77213] |
Wed, 17 November 2004 06:07  |
slim
Messages: 6
Registered: November 2004
|
Junior Member |
|
|
Hi,
I'm using oci whith php .
When i connect to my db (with ocilogon), i don't see nothing about it in v$session.
Is it normal ?
Thanks
|
|
|
|
| Re: OCI and Oracle SESSIONS [message #77215 is a reply to message #77213] |
Wed, 17 November 2004 06:45  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Maybe the session is closed after the OCI call?
You can keep the session alive by making it wait. Try including dbms_lock.sleep(10) to give you enough time to see the session. You could also update a row from sqlplus (don't commit) and then try to update the same from from the OCI (it will wait for the sqlplus rollback/commit).
|
|
|
|
|
|
| Re: OCI and Oracle SESSIONS [message #77219 is a reply to message #77218] |
Thu, 18 November 2004 00:49 |
slim
Messages: 6
Registered: November 2004
|
Junior Member |
|
|
I have put a lock on my oci program for 30 sec, and i can see the session in v$sessions, so the sessions is closed after de query is finished.
I use the oci_pconnect function (PHP5) to connect to my database it must create a persistent connection, but it seems that the sessions is closed.
Do you know what function i must use to keep the session alive ?
Thank you.
|
|
|
|
|
|
| Re: OCI and Oracle SESSIONS [message #77228 is a reply to message #77221] |
Thu, 18 November 2004 23:34 |
slim
Messages: 6
Registered: November 2004
|
Junior Member |
|
|
Hello,
Thanks for your response.
i would like to pass a connection ressource from page to page.(to prevent reconnecting from each page).
i tryed to do this using session in php, but we can not register a variable which type is ressource connection (got from oci_connect).
Any idea ?
Thanks a lot.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
