Re: Executing pkb withing an IF ..Then statment: PLS-00103 Encountered the symbol

NGrybov_at_gmail.com wrote:
> 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 ...
> begin

You can stop right here ... it should be

DECLARE
  variable declarations
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.org