Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04088: error during execution of trigger

SmileFeb 11 2009 — edited Feb 12 2009
Hi ,
I've written the following trigger.. trigger is created...The trigger is on a table for update statement..

But when i fire the update statement on the table getting the FOLLOWING ERROR:
ORA-01403: no data found
ORA-06512: at "AJ.T_REF_DBID", line 6
ORA-04088: error during execution of trigger 'AJ.T_REF_DBID'


But if i fire
UPDATE RE_SO_T SET SO_CD ='M'
Then getting the
ORA-01403: no data found
ORA-06512: at "AJ.T_REF_DBID", line 6
ORA-04088: error during execution of trigger 'AJ.T_REF_DBID'

BUT THE SELECT STMT AFTER THE BEGIN CLAUSE IN THE TRIGGER HAS SOME ROWS...

How to solve this issue????

Edited by: josh1612 on Feb 11, 2009 3:26 AM

Edited by: josh1612 on Feb 11, 2009 10:05 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2009
Added on Feb 11 2009
11 comments
2,588 views