OraFAQ Forum: SQL & PL/SQL » ORA-04088 on

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-04088 on - trigger execution (Oracle,11.2.0.1.0, AIX5.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04088 on - trigger execution [message #503797]

Tue, 19 April 2011 13:50

pchandna1
Messages: 24
Registered: March 2011
Location: USA

Junior Member

Folks,

The application log is experiencing ORA-04088 due to firing of below trigger. I see locks on underlying tables which now are released. Executed test insert still show same error; any clue?

Thanks

Attachment: trigger.sql
(Size: 0.87KB, Downloaded 884 times)

Report message to a moderator

Re: ORA-04088 on - trigger execution [message #503806 is a reply to message #503797]

Tue, 19 April 2011 14:47

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

RA-04088: error during execution of trigger '%s.%s'
*Cause:  A runtime error occurred during execution of a trigger.
*Action: Check the triggers which were involved in the operation.

Use SQL*Plus and copy and paste the session including the trigger creation and the statement that raises the error.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Previous Topic:	Index
Next Topic:	Convert LONG to CLOB in a PL/SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 04 03:24:37 CDT 2026