Home » SQL & PL/SQL » SQL & PL/SQL » TRIGGER ISSUES (ORACLE 10G)
TRIGGER ISSUES [message #307576] Wed, 19 March 2008 03:29 Go to next message
somto
Messages: 5
Registered: March 2008
Location: Lagos, Nigeria
Junior Member
UPDATING A TABLE TRIGGERED THIS ERROR:
ORA-04098:'SYSTEM.HRSALARY_AUDIT' IS INVALID AND FAILED REVALIDATION.
WHAT SHOULG I DO?
Re: TRIGGER ISSUES [message #307582 is a reply to message #307576] Wed, 19 March 2008 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fix your trigger.

And don't put anything in SYSTEM schema.

And please read OraFAQ Forum Guide, what is said about formatting and posting in upper case.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: TRIGGER ISSUES [message #307586 is a reply to message #307576] Wed, 19 March 2008 03:58 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
somto wrote on Wed, 19 March 2008 09:29
UPDATING A TABLE TRIGGERED THIS ERROR:
ORA-04098:'SYSTEM.HRSALARY_AUDIT' IS INVALID AND FAILED REVALIDATION.
WHAT SHOULG I DO?

Please don't shout.
Re: Trigger Issues [message #307595 is a reply to message #307586] Wed, 19 March 2008 04:17 Go to previous messageGo to next message
somto
Messages: 5
Registered: March 2008
Location: Lagos, Nigeria
Junior Member
Sorry, Thank you.

Updating different columns on a table resulted in this error:
ORA-04098:'SYSTEM.HRSALARY_AUDIT' IS INVALID AND FAILED REVALIDATION.
What should I do?


[Updated on: Wed, 19 March 2008 04:20]

Report message to a moderator

Re: Trigger Issues [message #307596 is a reply to message #307595] Wed, 19 March 2008 04:23 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The answer still is "Fix the trigger"

Do a

select * from user_errors;


as the trigger owner for example, to view the errors.

And then fix them, or post them and the trigger code here if you need help.
Re: Trigger Issues [message #307612 is a reply to message #307596] Wed, 19 March 2008 05:09 Go to previous message
somto
Messages: 5
Registered: March 2008
Location: Lagos, Nigeria
Junior Member
Thank you. Worked it out.
Previous Topic: How to compare the Varchar and Number in oracle10g
Next Topic: Sql query or pl/sql program
Goto Forum:
  


Current Time: Wed Dec 07 22:13:48 CST 2016

Total time taken to generate the page: 0.05883 seconds