Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problem Raise_application_error in Trigger

Problem Raise_application_error in Trigger

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 19 Jul 2004 22:43:26 -0700
Message-ID: <ea01504d.0407192143.35654d0b@posting.google.com>


Dear All,
I write a trigger on windows platform code is all follows.



SQL> desc accountmaster;
 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

CREATE OR REPLACE TRIGGER SCOTT.TRG_ACCOUNTMASTER_OPAMT     BEFORE INSERT OR
    UPDATE OF OPENINGAMOUNT
    ON ACCOUNTMASTER
    FOR EACH ROW WHEN (NEW.SUBLEDGER='T'     AND NEW.OPENINGAMOUNT<>0)
BEGIN
        raise_application_error(-20001, ' OPENINGAMOUNT Error.', TRUE); END;

Now when I giving insert statement

SQL> insert into accountmaster (OPENINGAMOUNT,SUBLEDGER) values (1000,'T'); insert into accountmaster (OPENINGAMOUNT,SUBLEDGER) values (1000,'T')

            *
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'

Now suggest me hot to remove these lines or is there some other way around????

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US