using stored procedures from pro*c

2002-07-31 Thread Adams, Matthew (GEA, MABG, 088130)
Title: using stored procedures from pro*c When calling a stored procedure (to do a select) from a pro*c program, does the sqlca.sqlerrd[2] row counter get set? Or does that happen only if you are putting the selects into the Pro*C program? It seems to act differently for different

Re: using stored procedures from pro*c

2002-07-31 Thread Tim Gorman
Title: using stored procedures from pro*c It is meaningless. PL/SQL blocks handle their own cursors within a single cursor employed by PRO*C, so the contents of "sqlca.sqlerrd[2]" are likely leftover from a previous call? You may have gotten the value you wanted in one vers