APP_STANDARD.EVENT throwing FRM-40735: WHEN-NEW-RECORD-INSTANCE unhandled exception ORA-06502
Problem Description: In one of our custom forms, the WHEN-NEW-RECORD-INSTANCE trigger raises an unhandled exception ORA-06502 when it is calling the standard package APP_STANDARD.EVENT('WHEN-NEW-RECORD-INSTANCE').
If this line is commented in the trigger, then the form is fine.
This error happens when we query records and everytime we go to a new record.
It seems to be happening for records with a column name called ORG_ID(VARCHAR2(15)) having character values. For records having ORG_ID as a numeric value, the form performs fine.
We have upgraded from 11.5.10 to 12.1.2
The form version, the table behind the form are all the same as they were in 11i before upgrade.
If this line is commented in the trigger, then the form is fine.
This error happens when we query records and everytime we go to a new record.
It seems to be happening for records with a column name called ORG_ID(VARCHAR2(15)) having character values. For records having ORG_ID as a numeric value, the form performs fine.
We have upgraded from 11.5.10 to 12.1.2
The form version, the table behind the form are all the same as they were in 11i before upgrade.
0