HELP:Power Builder does not execute Oracle Trigger.

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 21 Apr 1999 00:17:35 GMT
Message-ID: <371c6f7d.4832749@news.twsc.pouchen.com.tw>

Hello all,
I have a very strange problem about trigger. In SQL*Plus,connect as scott/tiger and create the trigger:

CREATE TRIGGER UPD_TEST

       BEFORE UPDATE
       ON EM_STOPPAY
       FOR EACH ROW

BEGIN
    /* Just want to test */
     RAISE_APPLICATION_ERROR(-20002,'TEST'); END UPD_TEST;
/

SQL> SELECT * FROM EM_STOPPAY; COMP FACT PNL_NO ST STOP_D HIRE_D REASON

---- ---- -------- -- -------- -------- ----------------------------------------

A001 C001 559559 10 19990401 19990401 A001 C001 010001 10 19990101 19990301 A001 C001 559971 10 19990401

SQL> UPDATE EM_STOPPAY SET STOP_D = '19990421'             WHERE FACT_NO = 'C001' AND PNL_NO = '559971';

            UPDATE EM_STOPPAY SET STOP_D = '19990421' 
            WHERE FACT_NO = 'C001' AND PNL_NO = '559971'

            ORA-20002: TEST
            ORA-06512: at "SCOTT.UPD_TEST"  line 2.
            ORA-04088: error during execution of trigger 'SCOTT.UPD_TEST'

BUT in Power Builder I connect as scott/tiger,too And then do the same update of em_stoppay, BUT the error message does not raise.
It's so strange.I need some help.
What's wrong with Power Builder??
Please give me any suggestion and Thank you very much.

Violin.
violin.hsiao_at_mail.pouchen.com.tw Received on Tue Apr 20 1999 - 19:17:35 CDT