| Regarding Error with Trigger [message #231727] |
Wed, 18 April 2007 04:53  |
chandrasekharbomminisidda
Messages: 21
Registered: March 2007
Location: Chennai
|
Junior Member |
|
|
Respected Sir,
I am having trigger
1 create or replace trigger ALL_REPORT_USER_tm_tr
2 before insert on ALL_REPORT_USER_tm
3 for each row
4 begin
5 if (:new.user_id is null) then
6 raise_application_error(-20001, 'Invalid u have to pass the user_id');
7 end if;
8 end;
Trigger created and when i tried to insert a null value in user_id i am getting the message which i raised through raise application error . In addition to that i am getting error also
The error i am getting is
ORA-06512: at "OTSLGWEB.ALL_REPORT_USER_TM_TR", line 3
ORA-04088: error during execution of trigger 'OTSLGWEB.ALL_REPORT_USER_TM_TR'
Even when i execute the command
show errors trigger all_report_user_tm_tr;
No errors for TRIGGER OTSLGWEB.ALL_REPORT_USER_TM_TR
It's giving the above message when i use the command show errors trigger trigger name.
Why it is giving me the error at for each row part.
Please give the solution for above said problem.
which will help me Sir.
Sincerely,
Chandrasekhar B.S
|
|
|
|
|
|
| Re: Regarding Error with Trigger [message #231748 is a reply to message #231731] |
Wed, 18 April 2007 05:36  |
chandrasekharbomminisidda
Messages: 21
Registered: March 2007
Location: Chennai
|
Junior Member |
|
|
The Error message i gave is coming completely, But inaddition to that ora-06512 and ora-04088 errors also coming I don't know why it is throwing that error messages. Even i was tried to use substr function in raise_application_error function also . I am getting the same. Please tell me regarding this
ORA-20001: Invalid u have to pass the user_id
ORA-06512: at "OTSLGWEB.ALL_REPORT_USER_TM_TR", line 3
ORA-04088: error during execution of trigger 'OTSLGWEB.ALL_REPORT_USER_TM_TR'
Regards,
Chandrasekhar B.S.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
