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.