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

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 22 Oct 2008 06:16:19 -0700
Message-ID: <1224681374.128279@bubbleator.drizzle.com>


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
Received on Wed Oct 22 2008 - 08:16:19 CDT

Original text of this message