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!

Error in insert - 11g Standard Edition

Discussion in 'SQL PL/SQL' started by LadyZero, Nov 11, 2013.

  1. LadyZero

    LadyZero Guest

    Hi all!
    I have encountered an error in a transaction.
    When the application try to insert n pdf or jpg files in a table (field in BLOB data type), in dependence on them sizes it fail.
    The errors generated are
    ORA-00604: error occurred at recursive SQL level string 1
    ORA-00001: unique constraint (SYS.I_OBJ1) violated

    but the sequence that populate the _id works!
    There's not a problem with the nextvalue of the sequence and the max value of the id column. They are different and the first one is bigger because of the failure of the last tried inserts.

    In another db the transaction works, and the only difference between the first and second database is the edition: where fail we have the Standard, the other is Enterprise.

    I was thinking about a maximum size in byte of an insert transaction with BLOB data type. Is it possible?
    Because when the sum of the byte size of the files is bigger than 2 MB it fail!
    Else, when the sum < 2MB, not.

    Any ideas about this? :(
  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    Not without more information. BLOB data types are not restricted to a 2 MB maximum size, so I doubt this is the issue. We won't know, however, until you post a valid test case including the create table statement, the create sequence statement and sample data.