Re: REF CURSOR

On Mar 27, 9:58 am, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Ok, this is probably a dumb question, but, I have this code:
>
> CREATE OR REPLACE PROCEDURE cj_trials_log (
>   p_newsletter_id      NUMBER,
>   p_conversion_date    VARCHAR2,
>   p_data               OUT REF_CRS) IS
>
> TYPE ref_crs IS REF CURSOR;
> .
> .
> .
>
> I think it is upset because I use the REF_CRS before it is defined.

I'm doing my best to be civil ... and, yes, it IS 'upset' because of your coding practices.

> But how can you do this in a procedure?  

You don't outside of a package.

> Since the parameter
> declaration comes first?

This is one reason there are packages, as well as procedures. Declare this in the package, then use it in the packaged procedire, it's fairly simple.

> Do you create a public type?  I'm not sure
> how to do that......

You also can't search the newsgroup for "ref cursor" and see what you find? Is it THAT difficult to use a search engine???

http://lmgtfy.com/?q=ref+cursor

David Fitzjarrell Received on Fri Mar 27 2009 - 13:50:19 CDT