DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: I think ...i am Fired....

  1. #1
    Join Date
    Apr 2001
    Posts
    126

    Question

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

  2. #2
    Join Date
    Jun 2001
    Location
    Belgium
    Posts
    13
    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

  3. #3
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Kinda difficult to guess without the trigger.

    - Chris

  4. #4
    Join Date
    Jul 2000
    Posts
    296
    Maybe something wrong with dual?
    Does
    SELECT COUNT(1) FROM dual
    return 1?


  5. #5
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192

    USE Some Meaningful SUBJECT.

    Thanks
    Chan
    OCP7.3/8.0/8i/9i
    Sun Certified Sys. Admin

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
  •  


Click Here to Expand Forum to Full Width