Puzzled: CURSOR in Package

From: jane <janeyiu_at_optonline.net>
Date: Sun, 18 Nov 2001 03:42:37 GMT
Message-ID: <N6GJ7.137775$%94.23036034_at_news02.optonline.net>

[Quoted] [Quoted] In Steve Feuerstein's book on package cursors, [Quoted] 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 Sun Nov 18 2001 - 04:42:37 CET