Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE Package
UTL_FILE Package [message #36783] Thu, 20 December 2001 05:49 Go to next message
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 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: Global variable in Oracle
Next Topic: HELP: 'table' must name a table which the user has access
Goto Forum:
  


Current Time: Tue Mar 31 12:24:11 CDT 2020