Kalau ALTER SYSTEM SET .... menggunakan SCOPE=SPFILE, syaratnya: database harus di restart terlebih dulu ....
Bowo --- In [email protected], 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! 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 <*> 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/
