Re: Puzzled: CURSOR in Package

Well, for functions and procedures in packages it is quite simple: if you want your function/procedure to be publicly accessed then you put the declaration in the package header too. I guess it is the same for cursors, but I cannot remember situations this being a usefull item... It might be handy though when you are buiding some kind of generic package with all kind of handy things in it

Hth

Marc

"jane" <janeyiu_at_optonline.net> wrote in message news:N6GJ7.137775$%94.23036034_at_news02.optonline.net...
> In Steve Feuerstein's book on package cursors,
> he talks about declaring cursors in package
> specifications like:
>
> CURSOR my_cur RETURN xxxx ;
>
> and put the SELECT in the body...
>
> but he doesn't say why this "should" be the way.
> Is this just for standard good practice ? What else ?
>
> So what's wrong with fully declaring cursor and putting
> SELECT in the spec ?
> Actually this way one doesn't have
> to deal with the RETURN clause. and you don't have
> the cursor in 2 places.
>
> Your insight is highly appreciated
> thanks
>
> jane
>
>
>
Received on Mon Nov 19 2001 - 08:28:19 CST