[indo-oracle] RUN STORE PROCEDURE FROM JOB SCHEDULER

[Asep Inbisco IT]

Dear teman-teman, sorry nih mau nanya lagi, saya buat job scheduler dari
oracle form sbb :

 

SYS.DBMS_SCHEDULER.CREATE_JOB

    (

       job_name        => 'TSDW'

      ,start_date      => TO_TIMESTAMP_TZ('2007/02/12 12:30:00.000000
+07:00','yyyy/mm/dd hh24:mi:ss.ff tzh:tzm')

      ,repeat_interval => NULL

      ,end_date        => NULL

      ,job_class       => 'DEFAULT_JOB_CLASS'

      ,job_type        => 'STORED_PROCEDURE'

      ,job_action      =>
'MYR.SALES_DET(:BLOCK12.TEXT_YEAR,:BLOCK12.TEXT_WEEK)'

      ,comments        => NULL

    );

 

Kenapa waktu dijalankan keluar pesan ORA-275452 : %s is an invalid name for
a database object,

 

Apakah ada yang salah pada saat memanggil store procedure? Apakah kalimat
,job_action      => 'MYR.SALES_DET(:BLOCK12.TEXT_YEAR,:BLOCK12.TEXT_WEEK)'
sudah benar?

 

 



[Non-text portions of this message have been removed]