Re: Executing a package

Hi John,

On 28/06/12 15:51, John Dorlon wrote:
> Flounder!
????

Hi Kent,

> I have created a package that I need to execute. Every time I try to
> execute said package a set parameters window comes up, I have to execute
> each procedure individually. What's worse is that the window closes
> after a procedure is executed. What happened to the ability to just
> execute an entire package at once?

A package? You cannot execute a package. You can execute a procedure or 
a function. A package is a neat way of "packaging" up a number of 
related procedures, functions, variables and/or types. You can the 
execute procedures or functions from within the package, but not the 
package itself.

Think DBMS_OUTPUT, for example. That's the package. But you execute 
DBMS_OUTPUT.PUT or DBMS_OUTPUT.PUT_LINE etc. Those are procedures within 
the package.

HTH

Cheers,
Norm.

-- 
Cheers,
Norm. [TeamT]




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/