Oracle Forms

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.