Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00604: error occurred at recursive SQL level 1
ORA-00604: error occurred at recursive SQL level 1 [message #254138] Wed, 25 July 2007 20:48 Go to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
I am getting the following error whenI try to create trigger



Create or replace trigger emp
after insert on emp
begin
null;
end;



Eror message
____________


ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01401: inserted value too large for column
ORA-06512: at line 5
Re: ORA-00604: error occurred at recursive SQL level 1 [message #254162 is a reply to message #254138] Thu, 26 July 2007 01:00 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First,
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Then,
Search for a CREATE or DDL trigger.

Regards
Michel
Previous Topic: qUERRY HELP
Next Topic: need suggestion with logic
Goto Forum:
  


Current Time: Sat Dec 10 20:48:12 CST 2016

Total time taken to generate the page: 0.10578 seconds