1 Reply Latest reply: Oct 6, 2012 1:40 AM by damorgan RSS

    The storage control blocks were destroyed.

    Shouby
      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.