Re: Pro C and PLSQL problem.

Joe,

I would be happy to look at the code if you would be so kind as to condense it to a form which includes only the essentials, prefereably something which I can run on my system (HP Unix) w/out much setup. I realize this means a bit of work on your part, but let me assure you that I've done this many times myself, and I realize that sometimes it's the only way to get someone else to help you because your problem seems pretty obscure. Sometimes doing this will even enable you to discover the problem yourself. Let me know when you've got a minimal sample packaged which exhibits the problem, and I'm sure you'll get at least five people to take a look.

In the meantime, have you tried testing the stored procedure from a PL/SQL script, thereby eliminating the Pro-C program from consideration? If you can reproduce the problem from SQLPlus that would be a major finding. Also, take a look at your exception handlers. You could be getting an exception and not handling it very well. That happened to me once; My program didn't hang, but it just died w/out notice.

Paul Cluiss
Dallas, Texas

Joe Condle 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.
>
> --
> 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:50:48 CST