8 Replies Latest reply: Aug 15, 2012 12:45 PM by 955974 RSS

    FRM-40508: oracle error:unable to INSERT record

    794404
      Hello,

      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,
      :ORDER_LINE_BLOCK.inv_id,
      :ORDER_LINE_BLOCK.qty);
      COMMIT;

      Thanks for any help.