Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Pro C and PLSQL problem.
A copy of this was sent to Joe Condle <condle_at_mars-systems.com>
(if that email address didn't require changing)
On Mon, 15 Nov 1999 11:03:01 -0500, you wrote:
> We are running Oracle 8.5.x.x on solaris 2.5. I have a pro C program
>that parses data from a file and then sends the values to a PLSQL
>program that either updates the tables or inserts the new data.
> Here is the familiar programming story ( I only made one change). I
>added an OUT value to the PLSQL program to use as an indicator that new
>records have been added to the table. I am going to use this indicator
>in the Pro C program to send email to inform users the new values. Since
>I have added the indicator variable to both Pro C and PLSQL my program
>now hangs. When I use dbx to step through the program I get to the line
>just before the if (sqlca.sqlcode < 0) goto sql_error. On the next step
>the program hangs. I get no errors from oracle, no core file, nothing.
>I have to kill the process to get it to end. I am convinced I made some
>dumb programming error but have been staring at for so long I can't see
>it. Any clues or suggestions would be appreciated.
lets see the code.
--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
Thomas Kyte tkyte_at_us.oracle.com Oracle Service Industries Reston, VA USA
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Nov 15 1999 - 10:28:30 CST