Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What to put in package specifications
"Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote in message
news:VCs9g.86466$dW3.312_at_newssvr21.news.prodigy.com...
> It's a given that public procedures and functions are declared in the
> package specification. But what general rule of thumb, if any, is used to
> decide whether an object such as a cursor should be put in the package
> specification or declared in the procedure itself in the package body?
>
>
Use normal scoping rules. Where do you want the object visible? Inside the
procedure only or global to all procedures?
Jim
Received on Sat May 13 2006 - 17:04:14 CDT
![]() |
![]() |