Enable All Compilation Warnings Using the DBMS_WARNING Package
CALL DBMS_WARNING.SET_WARNING_SETTING_STRING ('ENABLE:ALL', 'SESSION')
CREATE OR REPLACE PACKAGE trans_data AUTHID DEFINER AS
TYPE Transrec IS RECORD (
accounttype VARCHAR2(30) ,
ownername VARCHAR2(30) ,
balance REAL
);
min_balance constant real := 10.0;
PRAGMA DEPRECATE(min_balance , 'Minimum balance requirement has been removed.');
insufficient_funds EXCEPTION;
PRAGMA DEPRECATE (insufficient_funds , 'Exception no longer raised ');
END trans_data;