DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: ORA-01403: no data found, how do you solve this?

  1. #11
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Try:

    insert into platformmapkeys( platformid, keypart1indic, keypart2indic, keypart3indic )
    VALUES ( :new.platformid, v_keypart1indic, v_keypart2indic, v_keypart3indic );


    - Chris


  2. #12
    Join Date
    Dec 2000
    Posts
    87
    Chris, yes, I tried it, but I received this:

    ERROR at line 1:
    ORA-06502: PL/SQL: numeric or value error: character string buffer too small
    ORA-06512: at "FITS.ADDNEWPLATFORM", line 34
    ORA-20500: Trigger forces a rollback
    ORA-06512: at "FITS.TRI_PLATFORMMAPKEYS", line 39
    ORA-04088: error during execution of trigger 'FITS.TRI_PLATFORMMAPKEYS'
    ORA-06512: at "FITS.TRI_PLATFORMS", line 90
    ORA-04088: error during execution of trigger 'FITS.TRI_PLATFORMS'
    ORA-06512: at line 1

  3. #13
    Join Date
    Dec 2000
    Posts
    87
    The problem have been solved.
    The error occur because there is another trigger associated with the table 'platformmapkeys' that checks the existance of the platformid value just generated from platform table, since the transaction it's end yet so it will always fail.


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