Mungkin salah di baris ini Mas,
'MYR.SALES_DET(:BLOCK12.TEXT_YEAR,:BLOCK12.TEXT_WEEK)'
seharusnya
'MYR.SALES_DET('|| :BLOCK12.TEXT_YEAR || ',' || :BLOCK12.TEXT_WEEK
|| ')'
Bowo
--- In [email protected], Asep Inbisco IT <[EMAIL PROTECTED]>
wrote:
>
> 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]
>
