Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem Raise_application_error in Trigger
Dear All,
I write a trigger on windows platform code is all follows.
Name Null? Type ----------------------------------------- -------- ---------------------------- ACCOUNTCODE NOT NULL NUMBER(10) NAMEOFACCOUNT VARCHAR2(100) SUPERCODE NUMBER(10) OPENINGAMOUNT NUMBER(10,2) ACCOUNTGROUP VARCHAR2(20) SUBLEDGER CHAR(1) PAN VARCHAR2(20) ADDRESS1 VARCHAR2(70) ADDRESS2 VARCHAR2(70) ADDRESS3 VARCHAR2(70) CREDITLIMIT NUMBER(10,2) CREDITDAYS NUMBER(10) DOC VARCHAR2(10)Trigger Definition
========================================================
*
ERROR at line 1:
ORA-20001: OPENINGAMOUNT Error.------------------>[ I need only this line ]ORA-06512: at "SCOTT.TRG_ACCOUNTMASTER_OPAMT", line 2 ORA-04088: error during execution of trigger 'SCOTT.TRG_ACCOUNTMASTER_OPAMT'
ERROR at line 1:
ORA-06512: at "SCOTT.TRG_ACCOUNTMASTER_OPAMT", line 2
ORA-04088: error during execution of trigger 'SCOTT.TRG_ACCOUNTMASTER_OPAMT'
regards
Arijit Chatterjee
Received on Tue Jul 20 2004 - 00:43:26 CDT