Windows
I want to abilect the packages below automatically on all client bank!
How to run a file (using @) within an PL / SQL block?
My code was like this:
declare
a varchar2(500);
BEGIN
SELECT SUBSTR(FILE_SPEC, 1, INSTR(FILE_SPEC, '\', -1, 2) -1) into a
FROM DBA_LIBRARIES
WHERE LIBRARY_NAME = 'DBMS_SUMADV_LIB'
and rownum = 1;
EXECUTE IMMEDIATE('''@'||a||'\RDBMS\ADMIN\utlmail.sql''');
EXECUTE IMMEDIATE('''@'||a||'\RDBMS\ADMIN\prvtmail.plb''');
end;