-
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?
-
USE Some Meaningful SUBJECT.
Chan
OCP7.3/8.0/8i/9i
Sun Certified Sys. Admin
-
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
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|