ORA-04088: error during execution of trigger ORA-06508: PL/SQL: could not find program unit being called

I have a trigger created in one schema that in used on a table in another schema.

The trigger calls a procedure from a package , this package is defined as current user authid

I get the error when teh trigger reaches the point at which the function call is to be made.

but I dont knwo how to get around that problem... has any got any clues ??

create or replace
TRIGGER TEG.TR_AEC_COMPLETE_TASK_95
 AFTER
  UPDATE
 ON WMIS.wr_task
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
WHEN (NEW.wr_task_no = 100 AND
      NEW.task_status_code = 'C' AND
      OLD.task_status_code != 'C')
Declare
....
...
BEgin
..
..
-- follwoing two procs added to trigger
TEG.SPCKG_AEC_MSG_LOG.Application_Log_TEST  -- this call ok

TEG.SPCKG_AEC_BL_TSK_95_CMPLT.RESOLVE_SCHDLNG_PLYGN_5047 -- this is where oracle fails with teh error

..
exception
..
..
end;

this code works fine if i remove teh offending RESOLVE_SCHDLNG_PLYGN_5047 , but i need to add that proc to reslove an issue

this is the error i get

ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "TEG.TR_AEC_COMPLETE_TASK_95", line 294
ORA-04088: error during execution of trigger "TEG.TR_AEC_COMPLETE_TASK_95"       

I am thinking is some dort of prvilidges issue .. any clues ...
LVL 2
Jayesh AcharyaTechnichal ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

flow01Commented:
what user is updating table WMIS.wr_task

is the
TEG.SPCKG_AEC_BL_TSK_95_CMPLT.RESOLVE_SCHDLNG_PLYGN_5047 granted to that user ?

is the
TEG.SPCKG_AEC_BL_TSK_95_CMPLT.RESOLVE_SCHDLNG_PLYGN_5047 granted directly to that user :
by directly i mean
there is a "grant execute to user xxx on  TEG.SPCKG_AEC_BL_TSK_95_CMPLT.RESOLVE_SCHDLNG_PLYGN_5047"

and  not only a grant execute to a role the user has

for use within packages i did need such  direct grants , may same goes for triggers

PS (probably nothing to do with your problem)
i would expect a trigger on a WMIS-table to be owned by WMIS, I didn't even know another schema could own a trigger on a table in a different schema
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.