Re: Executing pkb withing an IF ..Then statment: PLS-00103 Encountered the symbol
Date: Wed, 22 Oct 2008 06:16:19 -0700
> Please help,
> I am trying to create a script for patching the database.
> The script works with INSERT or SELECT, but when i try to execute a
> package (*pkb). I get an error: "PLS-00103 Encountered the symbol
> CREATE when expecting one of the following: begin ...."
> The logic is like this :
> varable ...
> declare ...
You can stop right here ... it should be
BEGIN For examples of working packages you can use go to Morgan's Library at www.psoug.org and look up "Packages: User Defined."
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Oct 22 2008 - 08:16:19 CDT