Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Puzzled: CURSOR in Package

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@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 Sat Nov 17 2001 - 21:42:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US