I tried to compile a package and had some problems:
- can't understand status of package (valid or invalid) - there is not indication in database window
- package body was cut near the merge instraction. See an example below.
create table test_tab(id number, val nvarchar2(255));
create or replace package test_merge_pkg is
create or replace package body test_merge_pkg is
merge into test_tab d
using (select 1 id , '123' NM from bti_kl1 t) src
on (d.id = src.id)
when not matched then
when matched then
update set d.val = src.nm;
Under row "when matched then" I lost the rest of the package body.