Pro C and PLSQL problem.

From: Joe Condle <condle_at_mars-systems.com>
Date: Mon, 15 Nov 1999 11:03:01 -0500
Message-ID: <38302EB5.5996F870@mars-systems.com>

        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.

--

Joseph P. Condle Jr.      condle_at_mars-systems.com   Office 412-648-1379
Senior Systems Engineer                             Fax    412-647-9661
Medical ARchival Systems, Inc.  (MARS)              Pager  412-572-9490

3500 Victoria Street Pgh. Pa. 15261 USA Received on Mon Nov 15 1999 - 10:03:01 CST