Problem with ora_exec

Hi

I have a problem with ora_exec in that the page hangs and eventually
times out when attempting to use an sql statement updating the
database

The puzzling thing is that ora_exec works find when I am using select
statements to pull data from oracle but hangs when attempting to
update.

The sql generated by my script is correct as I printed it to the
screen then copied it into sqlplus and it updated everything as I
would expect using the same user that I am connecting with via php.

Any suggestions would be appreciated

Thanks

Derek

On 17 Sep 2003 02:49:10 -0700, derekabernethy@hotmail.com (Derek Abernethy)
wrote:

>I have a problem with ora_exec in that the page hangs and eventually
>times out when attempting to use an sql statement updating the
>database
>
>The puzzling thing is that ora_exec works find when I am using select
>statements to pull data from oracle but hangs when attempting to
>update.

Are you waiting for a lock?

Otherwise - post more info.

>The sql generated by my script is correct as I printed it to the
>screen then copied it into sqlplus and it updated everything as I
>would expect using the same user that I am connecting with via php.
>
>Any suggestions would be appreciated

I'd suggest to move to the oci8 extension, based on Oracle 8i, where the
Oracle Call Interface changed considerably, instead of the ancient and
unmaintained 'oracle' extension, which is based on Oracle 7.

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)