gudii9
asked on
error in executing trigger ddl
hi,
When executing trigger say TRG_XYZ following error coming like
ORA-04042: procedure, function, package, or package body does not exist
grant execute on TRG_XYZ to LMN_rolename_ROLE
can you please suggest. Any links, resources ideas highly appreciated. Thanks in advance
When executing trigger say TRG_XYZ following error coming like
ORA-04042: procedure, function, package, or package body does not exist
grant execute on TRG_XYZ to LMN_rolename_ROLE
can you please suggest. Any links, resources ideas highly appreciated. Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I gave already select, update, insert, delete at the start of this script file like
grant select,insert,update,delet e on abc_tableName to LMN_rolename_ROLE
even before running statement
grant execute on TRG_XYZ to LMN_rolename_ROLE
So this case I can igore and remove
the below statement right
grant execute on TRG_XYZ to LMN_rolename_ROLE ?
Please advise
grant select,insert,update,delet
even before running statement
grant execute on TRG_XYZ to LMN_rolename_ROLE
So this case I can igore and remove
the below statement right
grant execute on TRG_XYZ to LMN_rolename_ROLE ?
Please advise
yes remove
grant execute on TRG_XYZ to LMN_rolename_ROLE
grant execute on TRG_XYZ to LMN_rolename_ROLE
ASKER
Thank you very much. I appreciate it.
ASKER
create role LMN_rolename_ROLE;
They are not pointing to any table, or package or function etc as of now.
Trigger code also pretty simple as of now looks like
DROP TRIGGER TRG_XYZ ;
CREATE OR REPLACE TRIGGER TRG_XYZ
BEFORE INSERT
ON abc_tableName
FOR EACH ROW
BEGIN
IF :NEW.lmn_id IS NULL
THEN
SELECT seq_lmn_id.NEXTVAL
INTO :NEW.lmn_id
FROM DUAL;
END IF;
END;
Please advise. can I ignore trigger errors as of now ?. Or what is the best work around to avoid these errors. These ddls were generated in the first place from the toad etc db client tool by generating ddls of entire schema.