Belum bisa juga Mas Bowo, saya juga sudah search tapi belum ketemu juga, mungkin tipikalnya store procedure bila di run di job schedule tidak menggunakan parameter.
Salam Asep _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yulius Wibowo Sent: 12 Februari 2007 12:39 To: [email protected] Subject: [indo-oracle] Re: RUN STORE PROCEDURE FROM JOB SCHEDULER 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 indo-oracle@ <mailto:indo-oracle%40yahoogroups.com> yahoogroups.com, 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] > [Non-text portions of this message have been removed]
