Re: Forms error_text exception
From: <pwu_at_qantas.com.au>
Date: 17 Jan 2006 14:02:13 -0800
Message-ID: <1137535333.461060.89470_at_g14g2000cwa.googlegroups.com>
Date: 17 Jan 2006 14:02:13 -0800
Message-ID: <1137535333.461060.89470_at_g14g2000cwa.googlegroups.com>
The error I got was a form error:
ORA-06502 - PL/SQL: numeric or value error
The problem is not that the ERROR_TEXT needs to be put into a variable and then the variable put into the 'log' table.
I have tried this and this also fails.
Have you ever got ERROR_TEXT routine to give a non-blank text in a trigger other than ON-ERROR? Received on Tue Jan 17 2006 - 23:02:13 CET