I think ...i am Fired....

hi,

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
'GEO.LOG_BEFOREINSERT'

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.

- Chris

Maybe something wrong with dual?
Does
SELECT COUNT(1) FROM dual
return 1?

Thanks

I think that this thread is a replica of the following

http://www.dbasupport.com/forums/sho...threadid=11721


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.
Sam