ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.STANDARD", line 1014
ORA-06512: at "GEO.LOG_BEFOREINSERT", line 2
ORA-04088: error during execution of trigger
i am getting this error when i tried to indert in a table even one record..
Does this trigger selects from a sequence ?
How many records are there in the table dual ?
There should be only one record.
select count(*) from dual;
If there is only one record ... how many tables dual do exist ?
select owner, table_name from dba_tables where table_name = 'DUAL';
PS : you don't get fired that easy
Kinda difficult to guess without the trigger.
Maybe something wrong with dual?
SELECT COUNT(1) FROM dual
USE Some Meaningful SUBJECT.
Sun Certified Sys. Admin
I think that this thread is a replica of the following
It had already been well answered, and I take the liberty to close this thread. If it needs to be reopend, please post a message or send a request to any of the moderators.
Thanx for the coporation.
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width