oracle-databaseoracleformsora-06502

Check the checkbox on run-time

I have a data block called LOAN and item called DOC_8 which is a checkbox. On run-time I would like to check the checkbox item DOC_8. When using the following code:

:LOAN.DOC_8 := 'Y';

I got the following error

FRM-40735: POST-QUERY trigger raised unhandled exception ORA-06502.

Please help, I'm very new to this.

Solution

  • Error ORA-06502 raises due to two cases occur:

    1. If the value doesn't fit in a variable, or data type violated
    2. A NULL value is assigned to a variable which's defined as NOT NULL

    It seems in your case that the Data type in your checkbox's Property Palette is not defined as a string, perhaps numeric.