Re: OCI oexec() hanging -- how to debug?

In article <1995Sep22.232019.19191_at_igs.com>, bgeerdes_at_igs.com (Bruce Geerdes) wrote:

> 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.W95
Can you let me have some more info? I assume you are using C as the programming language. How are you linking the OCI (this is one of the most tricky, undocumented areas of OCI as far as I can tell). Are there any triggers of constraints on the tap table? Is another transaction liable to lock you out during the insert (say, by takinging an exclusive lock on to a table that is the subject of a trigger?)

Telephone: (+44)-0181-852-1605           -------
Cellphone: 0860-290883                   OSIRIS \ CONSULTANTS
"The view expressed here are both mine and        ------------