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

From: DA Morgan <>
Date: Wed, 22 Oct 2008 06:16:19 -0700
Message-ID: <> 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

  variable declarations
BEGIN For examples of working packages you can use go to Morgan's Library at and look up "Packages: User Defined."

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Oct 22 2008 - 08:16:19 CDT

Original text of this message