Hi all,

Just came across a rather interesting problem while trying to set up Oracle with PHP -

All other statements work fine, but when I try to call an UPDATE statement, it seems to hang when calling OCIExecute (). The same query works fine in SQL*Plus, but for some unknown reason, calling OCIExecute () on an update statement doesn't seem to work.

Anybody seen this before?

Thanks

-- John G.

    John,

    I have seen something like this before, and have been the cause.

    Question - Do you have sqlplus open when you are doing this? ie. you have been doing some inserts and updates or even deletes and not typed commit. Sometimes the tables seem to lock. And PHP can not update the tables.

    Let me know,

    Chris

      Hey - good one! It worked!

        14 years later

        Super old post, but I can't say thanks enough! I was beating my head on the table forever trying to figure out what the deal with this was.

        My query was working just fine in my Oracle SQL Developer tool, but when it was executed in PHP it hung until I restarted my entire WAMP server.

        When I closed out Oracle SQL Developer, voila! No problem.

        Thanks so much guys.

          Write a Reply...