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 -> Re: What to put in package specifications

Re: What to put in package specifications

From: Jim Kennedy <jim>
Date: Sat, 13 May 2006 15:04:14 -0700
Message-ID: <FOSdnbjSz9LYyvvZnZ2dnUVZ_vGdnZ2d@comcast.com>

"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

Original text of this message

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