8 Replies Latest reply on Aug 15, 2012 5:45 PM by 955974

    FRM-40508: oracle error:unable to INSERT record


      I'm creating a form with forms builder (oracle 10g) and I created one control block (i converted the data block to a control block) and a detail data block (detail block was created using the wizard).

      There is a save button in the detail data block which generates a trigger to insert the record in the DB. But it gives the error "FRM-40508: oracle error:unable to INSERT record", but when I manually insert the same record through SQL it works fine.

      The user has all the privilages in the DB.

      This is the trigger code to insert the record:

      INSERT INTO order_line VALUES
      (: ORDER_BLOCK.order_id,

      Thanks for any help.