UTL_FILE Package [message #36783] |
Thu, 20 December 2001 05:49 |
SANDRIN PL
Messages: 1 Registered: December 2001
|
Junior Member |
|
|
Hi,
I want to use UTL_FILE Package, can you say me how to install this package and execute him
It's urgent for my work
Thank you very much.
Please answer in easy english, I'm french.
PL
----------------------------------------------------------------------
|
|
|
Re: UTL_FILE Package [message #36784 is a reply to message #36783] |
Thu, 20 December 2001 09:17 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
first, check utl_file already installed or not
SQL> desc utl_file
if not installed, run utlfile.sql script file
(you can find that file in oracle_homerdbmsadmin
connect to sys account and run above said file.
open init.ora file
set utl_file_dir parameter
utl_file_dir=c:somedir
shutdown database
start database
now, you should be able to use utl_file package.
----------------------------------------------------------------------
|
|
|