Mungkin karena set-nya baru di spfile, jadi harus
di-restart dulu databasenya.
Btw, kalau sudah pakai 9i, lebih baik jangan
menggunakan utl_file_dir lagi, karena tidak fleksibel
(harus restart db).
Di 9i ada objek directory yg lebih fleksibel,
lokasinya bisa dimana saja selama user Oracle bisa
mengakses dir tsb. Selain itu privilege read dan write
directory bisa digrant ke user lain, jadi lebih enak
di-manage.
Kalau sudah pernah pakai utl_file dengan utl_file_dir,
utk mengubahnya menjadi pake directory sangat gampang.
Pertama buat dulu object directory:
create directory mydir as 'c:\';
Terus grant privilege ke yg mau akses:
grant read on directory mydir to user1; --baca
grant write on directory mydir to user1; --tulis
Dr programnya tinggal diubah jadi:
vfile:=UTL_FILE.FOPEN('MYDIR','stok.txt','W');
regards,
tomi
--- agus sulaiman <[EMAIL PROTECTED]> wrote:
> Kepada teman-teman semuanya,
> Saya sudah mencoba melakukan alter system
> set utl_file_dir='c:\' scope=spfile pada database
> oracle 9i ,tetapi setelah saya menjalankan pl/sqll
> ini:
> declare
> vfile UTL_file.file_type;
> cursor c_stok is
> select kdstok,nastok from TBLstok where rownum <
> 10;
> vdata varchar2(200);
> begin
> vfile:=UTL_FILE.FOPEN('C:\','stok.txt','W');
> for fs in c_stok loop
>
> vdata:=rpad(fs.kdstok,23)||rpad(fs.nastok,30);
> utl_file.PUT_LINE(VFILE,VDATA);
> end loop;
> UTL_FILE.fclose(vfile);
> exception
> when others then
> dbms_output.put_line('Error
> '||sqlcode||sqlerrm);
> end;
> /
> maka terjadi error : Error -29280ORA-29280:
> invalid directory path.
> Tetapi bila saya menggunakkan database oracle
> versi 8.05 ,saya menset di parameter orcl. dan
> pl/sql tersebut dijalankan tanpa ada masalah.
> apa ada settingan khusus mengenai utl_file_dir
> pada database oracle versi 9i ?
> mungkin teman-teman ada yang pernah mencobanya.
>
> Thanks,
>
> Agus.
>
>
>
>
> ---------------------------------
> How low will we go? Check out Yahoo! Messengers low
> PC-to-Phone call rates.
>
> [Non-text portions of this message have been
> removed]
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
