BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
( job_name => 'TSDW'
,start_date => TO_TIMESTAMP_TZ('2007/02/12
06:25: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'
,number_of_arguments => 2
,comments => NULL
);
-- **** Tambahkan di sini
dbms_scheduler.set_job_argument_value(job_name => 'TSDW',
argument_position => 1,
argument_value => :BLOCK12.TEXT_YEAR);
dbms_scheduler.set_job_argument_value(job_name => 'TSDW',
argument_position => 2,
argument_value => :BLOCK12.TEXT_WEEK );
END;
/
--- In [email protected], Asep Inbisco IT <[EMAIL PROTECTED]>
wrote:
>
> 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:indo-
[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 <asep.it@>
> 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]
>
