Re: Pro*C

In article <2skqhe$bqk_at_source.asset.com>, karnesj_at_source.asset.com (John A. Karnes) wrote:

> 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

Could you post the code for your function? I am not sure what you are trying to accomplish.

Jeff

-- 
Jeffrey S. Little
Eli Lilly & Co.
little_jeffrey_s_at_lilly.com

I work in Systems, not in Corporate Communications.  Therefore, the
opinions I present are mine, not Eli Lilly's.

Yes I am a Pacer fan!
/=========\
||        ||
||        ||
|| Pacers!||
||        /
||       /
||=======
||
||
||