dari http://www.jlcomp.demon.co.uk/faq/utl_file.htmlSQL> connect system Enter password: ****** Connected.
SQL> create directory utl_file_dir as 'c:\temp\utl_file'; Directory created. SQL> grant write,read on directory utl_file_dir to scott; Grant succeeded. Then in a DOS session, create a folder which has the name slightly different from that already used : C:\>mkdir c:\temp\UTL_FILE C:\>Back in SQLPlus again, we connect as Scott and create a procedute to dump the EMP table to a text file, similar to the examples above. SQL> connect scott/tiger Connected. SQL> CREATE OR REPLACE PROCEDURE Empflatfile 2 IS 3 file_id UTL_FILE.FILE_TYPE; 4 BEGIN 5 file_id := utl_file.FOPEN( 'utl_file_dir', 'test.txt', 'w' ); 6 FOR emp IN (SELECT ename FROM emp) 7 LOOP 8 utl_file.PUT_LINE( file_id, emp.ename ); 9 END LOOP;anda udah bikin directory di sisi server belum?regards --ujang ----- Original Message ----- From: "agus sulaiman" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Wednesday, April 05, 2006 1:59 PM 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 Send instant messages to your online friends http://asia.messenger.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/
