Trigger Error

[amolso]

When I write triggers on any tables,
Every Trigger Gives me the following error

ORA-20000: SALEis not a valid room
ORA-06512: at "SCOTT.TRG1", line 7
ORA-04088: error during execution of trigger 'SCOTT.TRG1'

Out of above ORA-20000 is written by me in the trigger
definition.
The trigger is getting created without errors

Can you please explain me why above 2 errors
comes each and every time I try to use any entry
violating the conditions
Thanking you in Advance
amol [sig][/sig]

 

[MikeLacey]

Hi amolso,

Could you post your trigger code please? (if it's not *too* long that is <smile>) [sig]<p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br> [/sig]

 

[yaffle]

The two additional errors are generic messages that Oracle issues to give further information over and above the specific error. ORA-06512 is issued each time an error occurs within a SQL block and tells you where the error occurred, ORA-04088 is similar but specific to triggers. [sig][/sig]