Executing pkb withing an IF ..Then statment: PLS-00103 Encountered the symbol
Date: Wed, 22 Oct 2008 02:46:51 -0700 (PDT)
Message-ID: <f3f59422-57b2-405c-9e11-36d3807c4281@v72g2000hsv.googlegroups.com>
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
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:46:51 CDT