Re: PLS-00103 Encountered the symbol CREATE

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 22 Oct 2008 13:08:52 +0200
Message-ID: <48ff09cf$0$185$e4fe514c@news.xs4all.nl>

<NGrybov_at_gmail.com> schreef in bericht
news:bbadce27-941c-4957-9b06-2b803a2cd6ae_at_t65g2000hsf.googlegroups.com...
> Please help,
> I amd 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 on of the following: begin ...."
>
> The logic is like this
>
> varable ...
> ..
>
> declare ...
>
> begin
>
> Select c INTO a FROM test_table
>
> if :a=:b then
>
> @PG_TEST.pkb; (if in place of pkb i have simple script with INSERT or
> SELECT there are no problems)
>
> insert into test_table values((select max(id) from test_table) + 1,
> 'success');
>
> else
> ...
>
> end if;
> commit;
>
> Exception when others then
> rollback work;
> end;
> .
> /
> exit;
>
>
> Please help, What i am doing wrong?
>
> Thank you in advance.

You can not execute a package body; or are you CREATING a package body in your .PKB file?

Shakespeare Received on Wed Oct 22 2008 - 06:08:52 CDT

Original text of this message