Re: Manipulating a ref cursor

cherl wrote:
> I have a stored procedure that returns a ref cursor. The examples I've
> seen of ref cursor's always have the stored procedure that hold the ref
> cursor open it and then pass it back for the other procedure to fetch
> the data.
> The question i have is this. Is there a way to manipulate that cursor
> once it's been opened? So for instance
> the following code
>
> tsql := Select * from account_holder';
> open iocsr_acct_hldr for tsql;
> return iocsr_acct_hldr for tsql:
>
> In the calling program would I be able to fetch just for specific
> account holders?
> Could I do a sum on an amount field in the table etc?
> If so any idea where I can find some sample code?
>
> I know i could just change tsql and add a where clause but i'm trying
> to make one procedure that multiple people can use based on their own
> requirements.
> Thanks

Instead of asking ... try it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org