This discussion is archived
1 Reply Latest reply: Oct 5, 2012 11:40 PM by damorgan RSS

The storage control blocks were destroyed.

Shouby Newbie
Currently Being Moderated
Hi 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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points