Home » SQL & PL/SQL » SQL & PL/SQL » Trigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation
icon4.gif  Trigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation [message #273920] Fri, 12 October 2007 04:22 Go to next message
pats.vikas4184
Messages: 3
Registered: October 2007
Location: Pune
Junior Member

[Updated on: Fri, 12 October 2007 10:22] by Moderator

Report message to a moderator

Re: rigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation [message #273923 is a reply to message #273920] Fri, 12 October 2007 04:34 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Any chance of you actually explaining what you want?

I could have a stab at fixing your problem, but frankly, if you can't be bothered telling me clearly what it is, I can't be bothered trying to fix it.
Re: rigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation [message #273926 is a reply to message #273920] Fri, 12 October 2007 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fix the problem.

Regards
Michel
Re: Trigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation [message #273940 is a reply to message #273923] Fri, 12 October 2007 05:15 Go to previous messageGo to next message
pats.vikas4184
Messages: 3
Registered: October 2007
Location: Pune
Junior Member
salary adjust is trigger written on emp table such that whenever sal column in emp table is updated or inserted to 0 trigger will get executed.
but after executing update query on emp table it is giving me this error Trigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation .
Re: Trigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation [message #273941 is a reply to message #273940] Fri, 12 October 2007 05:27 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Why not use a check constraint? Why create a trigger that only raises an error if a given column value is below a threshold?

MHE
Re: Trigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation [message #273945 is a reply to message #273941] Fri, 12 October 2007 05:48 Go to previous messageGo to next message
pats.vikas4184
Messages: 3
Registered: October 2007
Location: Pune
Junior Member
I am a beginner,
so just trying to use a trigger on such condn.
i will try out using check constraint,
but let me know what is that error trigger invalid and failed revalidation.

[mod-edit] removed illiterate IM speak.

[Updated on: Fri, 12 October 2007 07:55] by Moderator

Report message to a moderator

Re: Trigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation [message #273946 is a reply to message #273945] Fri, 12 October 2007 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Application Developer's Guide - Fundamentals
PL/SQL User's Guide and Reference

Regards
Michel
Re: Trigger 'SCOTT.SALARY_ADJUST' is invalid and failed re-validation [message #273972 is a reply to message #273945] Fri, 12 October 2007 07:58 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you have an error in your code and you want us to help you with it, whatever you do , do NOT post the code!
We love guessing. You can find us in the bookies' offices every weekend polishing our crystal balls.

Seriously. Post your code. Use code tags to keep it readable.
Previous Topic: Multi Level Nested Tables
Next Topic: need help in exception handling
Goto Forum:
  


Current Time: Sat Dec 10 08:50:12 CST 2016

Total time taken to generate the page: 0.15721 seconds