OraFAQ Forum: Weblogic & Application Server » Problem with select for update and PHP

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Problem with select for update and PHP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with select for update and PHP [message #77133]

Thu, 16 September 2004 00:59

Chris
Messages: 128
Registered: November 1998

Senior Member

Hi

Hi have a problem with � query:

When i send an select......for update width PHP, i can t� lock my "table".

I am checking the lock with an SQLPLUS session

If i lock my table with SQLPLUS, PHP can t�make an select for update ---[>] it is OK
But if i try to lock with PHP i can make an other select for update
with sqlplus---[>] it is KO
So my lock doesn t work

If someone can help me .....

Report message to a moderator

Re: Problem with select for update and PHP [message #77134 is a reply to message #77133]

Thu, 16 September 2004 06:51

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

It is probably because PHP sessions are not persistent.

Your program will connect to the database, establish the lock, and then disconnect. When it disconnects, the lock will be released.

Best regards.

Frank

Report message to a moderator

Re: Problem with select for update and PHP [message #77136 is a reply to message #77134]

Thu, 16 September 2004 22:05

Chris
Messages: 128
Registered: November 1998

Senior Member

Hi,

I use the "ociplogon"
ociplogon -- Connect to an Oracle database using a persistent connection
So it must stay connected
No ?

Report message to a moderator

Re: Problem with select for update and PHP [message #77138 is a reply to message #77134]

Thu, 16 September 2004 22:11

Chris
Messages: 128
Registered: November 1998

Senior Member

Hi,

I use the "ociplogon"
ociplogon -- Connect to an Oracle database using a persistent connection
So it must stay connected
No ?

Report message to a moderator

Re: Problem with select for update and PHP [message #77261 is a reply to message #77136]

Fri, 17 December 2004 00:10

Matt Darby
Messages: 5
Registered: January 2003

Junior Member

Not if it's an intranet application. You're dealing with a disconnected recordset architecture. Have a look at the manual on www.php.net. ociplogon is the same as ocilogon for an intranet app.

Report message to a moderator

Previous Topic:	To avoid display of File Download dialog box when submitting a JSP
Next Topic:	books on oracle apps DBA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 03:46:25 CDT 2024