Dear Pro*C users,
I have written a subroutine (function) in Pro*C that when
passed certain information, uses that information to look up a value
(possibly more than one value). The problem I am having is that I use
a cursor to store the results of the select statement which works fine
the _first_ time the function is called, but when the subroutine ends
and I close the cursor, the information remains in the cursor. Thus,
the next time I call the function, I get my new information plus the
information from all previous calls to the function. Basically my big
question is this:
Is there a way to clear a cursor after you have fetched the values
from it?
I really need to get this working soon, and would greatly appreciate
any help. Thanks.
John Karnes
Software Engineer