Re: Need to execute procedure or package

From: Ed Prochak <prochak_at_my-dejanews.com>
Date: Thu, 15 Apr 1999 16:32:16 GMT
Message-ID: <7f54ag$oqk$1@nnrp1.dejanews.com>

In article <7f4u5k$iru$1_at_nnrp1.dejanews.com>, drider_trans_at_my-dejanews.com wrote:
> I inherited responsibility for a small database that has as far as I am told
> one stand alone procedure and a package with what looks like three
> procedures. I don't know how to run these. Can someone tell me how?
> Thanks.

[snip package description]

From SQL*Plus,

EXECUTE procedure(parameters) ;

or if it is in a package

EXECUTE packagename.procedure(parameters) ;

You really ought to read your manuals.

--
Ed Prochak
Magic Interface, Ltd.
ORACLE services
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 15 1999 - 11:32:16 CDT