Dear Mas Rohmad,
Berikut Detailnya :
1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
2 DBMS_SCHEDULER.CREATE_JOB(
job_name=>'jobsqlldr',
job_type=>'EXECUTABLE',
job_action=> 'u01/test/test.sh',
enabled=>true,
auto_drop=>true);
Isi scriptnya : sqlldr userid=usr/[EMAIL PROTECTED] control=
/u01/test/test.ctl data=/u01/test/TEST.csv
3. ORA-27369: job of type EXECUTABLE failed with exit code: 255
STANDARD_ERROR="execve: Exec format error"
=========================================
>
> Dear All,
> urgent nih.
>
> Saya belum dapat settingan yang pas DBMS_SCHEDULER external job
untuk Oracle
> 10.2.0.1. Karena di oracle 10.2.0.1 belum ada externaljob.ora bagaimana
> settingan yang tepat ???
> server menggunakan Linux
>
> sampai sekarang saya masih mendapatkan errror :
> ORA-27369: job of type EXECUTABLE failed with exit code: 255
> STANDARD_ERROR="execve: Exec format error"
>
> Terima Kasih
>
Terima Kasih
