1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

save exception

Discussion in 'SQL PL/SQL' started by bnramesh8, Jun 12, 2014.

  1. bnramesh8

    bnramesh8 Active Member

    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    80
    Hi,
    What are the methods that are present in save exception?where we can use that methods?
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi,

    I suppose you mean by "SAVE EXCEPTIONS" clause which is invoked in a "FORALL" DML statement ?

    This clause indicates the FORALL to process all the rows even when an error has occurred and "saving" the exceptions that are generated into a pseudo-collection SQL%BULK_EXCEPTIONS.
     
  3. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    There is another exceptions clause, when enabling a constraint, to save 'exceptions' into a table named, oddly enough, EXCEPTIONS.