Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

in package authid current_user not current user table trigger running

user3970448Aug 4 2021 — edited Aug 4 2021

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,
This post has been answered by Solomon Yakobson on Aug 4 2021
Jump to Answer

Comments

Post Details

Added on Aug 4 2021
#pl-sql, #trigger
2 comments
484 views