Hi!
there is a problem below
Database version: 19c
schema 1: PKG_OWNER
table: PKG_OWNER.table1 (empty)
trigger: PKG_OWNER.table1_upd
package: PKG_OWNER.test_pkg authid current_user update table1
schema 2: PKG_CALLER
table: PKG_CALLER.table1 (not empty)
trigger: PKG_CALLER.table1_upd
synonym: PKG_CALLER.test_pkg for PKG_OWNER.test_pkg
Test:
logon : PKG_CALLER user
begin test_pgk.proc1; end; --> dml: update table1 (--> current user: PKG_CALLER.table1)
-> error: PKG_OWNER.table1_upd trigger -> no data found
so it is not the PKG_CALLER.table1_upd trigger that is called, but the PKG_OWNER.table1_upd
specific error message:
LOGON: BCST_DB
ORA-01403: nincs adat
ORA-06512: a(z)
"NORBO_DB.KES_BIZFEJ_UPD", helyen a(z) 22. sornál
ORA-04088: hiba a(z) 'NORBO_DB.KES_BIZFEJ_UPD' trigger futása közben
Please anyone share your suggestions
Thanks,