I am trying to transfer a file from a remote pc on the network to my pc.
I have written a batch file for it, that batch file is working fine but when I try to execute it through oracle jobs it gives me error.
CREATE OR REPLACE PROCEDURE EXECUTE_BAT_FILE
DBMS_SCHEDULER.RUN_JOB( 'MYJOB', TRUE );
and this is the error i get
ORA-27369: job of type EXECUTABLE failed with exit code: The storage control blocks were destroyed.
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at "SYS.EXECUTE_BAT_FILE", line 5
ORA-06512: at line 1