coba ditambahkan pada file init(SID).ora utl_file_dir=C:\
restart deh oraclenya.... agus sulaiman <[EMAIL PROTECTED]> Sent by: [email protected] 05/04/2006 13:59 Please respond to [email protected] To [email protected] cc Subject [indo-oracle] utl_file_dir 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! Messenger?s 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 [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/
