Azhar
Member
create or replace trigger trg_test before update on test_table for each row
--This is test procedure
declare
No_CONF_FOR_fOUND Exception;
PRAGMA EXCEPTION_INIT(No_CONF_FOR_fOUND, 100 );
begin
Begin
DBMS_OUTPUT.put_line('My Code');
Exception when No_CONF_FOR_fOUND then
-- %raises No_CONF_FOR_fOUND if No configuration is defined in KRN_REPAIR_JOB_CARD_CONFG , OR Either TRANSACTION RESON OR COST CENTER IS EMPTY IN TABLE
RAISE_APPLICATION_ERROR(-20000,' No Configuration found for Job Card ');
End;
end trg_test;
---
This Has Following out put :
Trigger trg_test
********************** OUT PUT ***************
trigger trg_test before update on test_table for each row
This is test procedure
********************* PROBLEM ****************
This is not desire Out put is it BUG or i m not handling it prperly
--This is test procedure
declare
No_CONF_FOR_fOUND Exception;
PRAGMA EXCEPTION_INIT(No_CONF_FOR_fOUND, 100 );
begin
Begin
DBMS_OUTPUT.put_line('My Code');
Exception when No_CONF_FOR_fOUND then
-- %raises No_CONF_FOR_fOUND if No configuration is defined in KRN_REPAIR_JOB_CARD_CONFG , OR Either TRANSACTION RESON OR COST CENTER IS EMPTY IN TABLE
RAISE_APPLICATION_ERROR(-20000,' No Configuration found for Job Card ');
End;
end trg_test;
---
This Has Following out put :
Trigger trg_test
********************** OUT PUT ***************
trigger trg_test before update on test_table for each row
This is test procedure
********************* PROBLEM ****************
This is not desire Out put is it BUG or i m not handling it prperly