Re: Stored Procedure Problem

John De Lello wrote:

> Hi Daniel,
>
> Thanks for the reply. I'm not really sure I understand what you are saying.
> How would I modify the OPEN to allow a variable in the WHERE then?
>
> Thank you
> John D

What you wrote is:
TYPE cur_GetGroupSids IS REF CURSOR
in your package header

What you wrote in the procedure is:
OPEN resultcursor FOR

I am suggesting you do something like this: OPEN cur_GetGroupSids IS

In other words open the REF CURSOR ... not the TYPE.

Take a look at this demo:
http://www.psoug.org/reference/ref_cursors.html

Note the example labeled "Child Procedure".

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)