The storage control blocks were destroyed.
ShoubySep 25 2012 — edited Oct 6 2012Hi all,
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.
below is my coding
BEGIN
DBMS_SCHEDULER.CREATE_CREDENTIAL( CREDENTIAL_NAME => 'MY_CREDENTIAL', USERNAME => 'Administrator', PASSWORD => 'PW' );
END;
BEGIN
DBMS_SCHEDULER.CREATE_JOB( JOB_NAME => 'MYJOB',
JOB_TYPE => 'EXECUTABLE',
JOB_ACTION => 'c:\test.bat',
ENABLED => FALSE,
COMMENTS => 'runs test.bat',
CREDENTIAL_NAME => 'MY_CREDENTIAL' );
END;
CREATE OR REPLACE PROCEDURE EXECUTE_BAT_FILE
IS
BEGIN
DBMS_SCHEDULER.RUN_JOB( 'MYJOB', TRUE );
END EXECUTE_BAT_FILE;
EXEC EXECUTE_BAT_FILE
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
Please help.