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
<*> 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/
