PLS-00103 Encountered the symbol CREATE

From: <NGrybov_at_gmail.com>
Date: Wed, 22 Oct 2008 02:26:15 -0700 (PDT)
Message-ID: <bbadce27-941c-4957-9b06-2b803a2cd6ae@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. Received on Wed Oct 22 2008 - 04:26:15 CDT

Original text of this message