OCI oexec() hanging -- how to debug?
From: Bruce Geerdes <bgeerdes_at_igs.com>
Date: 1995/09/22
Message-ID: <1995Sep22.232019.19191_at_igs.com>#1/1
Date: 1995/09/22
Message-ID: <1995Sep22.232019.19191_at_igs.com>#1/1
I am looking for suggestions on how to figure out why oexec() is hanging. I am not very familiar with Oracle tools, so any pointers would be greatly appreciated!
oexec() sometimes hangs when I try to insert 2 integers into my database ("insert into tap (id, branch) values (:1, :2)"). I am using obndrn() to bind my variables. What troubles me the most is sometimes it works! Most of the time, however, it just hangs until I hit ctrl-c, after which is gives me the error
ORA-01013: user requested cancel of current operation Processing OCI function OEXEC, OEXN
Since it works some of the time, I am inclined to think something is wrong on the Oracle side, but I have no idea how to go about investigating this.
Suggestions?
-- bgeerdes_at_igs.com (Bruce Geerdes) C:\ONGRTLNS.W95Received on Fri Sep 22 1995 - 00:00:00 CEST