Home » RDBMS Server » Server Administration » Util
Util [message #245227] Fri, 15 June 2007 10:31 Go to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi all,

Does anybody knows how to create the util directory??? One of the user wants this directory to be created so that when the procedures are run, the files will be saved in this directory for the future lookup.I guess I will have to add a parameter in the init file as well.I looked up in the metalink, I didnt come up with anything. Also in google, I couldnt find anything.

Help greatly appreciated.
Thanks
Re: Util [message #245228 is a reply to message #245227] Fri, 15 June 2007 10:42 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
i have never workd on this scenario,but i am sure you are talking about UTL_FILE and UTL_FILE_DIR parameters.
Re: Util [message #245235 is a reply to message #245228] Fri, 15 June 2007 10:57 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Ohhhhh, I wanna play "guess the questions meaning", too. Wink

I have seen a "util" directory in Oracle Apps once, some sort of external plugin-thingies could be saved there.
Re: Util [message #245241 is a reply to message #245227] Fri, 15 June 2007 11:18 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
play "guess the questions meaning"
what is that
Re: Util [message #245243 is a reply to message #245227] Fri, 15 June 2007 11:24 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
I am sorry...you are right its Utl_file.

I have oracle 10.2.0.1.0 on windows xp. I did the below commands to create the directory:

SQL> 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 ctxsys;
Grant succeeded.

And in the cmd,

C:\>mkdir c:\temp\UTL_FILE

Connected as ctxsys and ran a sample procedure and executed the procedure.Below is the error:

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'example'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

But, I dont see any file in the created directory under temp\utl_file.

Please give me your comments.Thanks!
Re: Util [message #245246 is a reply to message #245227] Fri, 15 June 2007 11:28 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
>Please give me your comments.Thanks!
Why do you expect us to debug your code when you don't post it??????????????????????

Could you debug my code if I simply posted an arbitrary error code/message?

You're On Your Own (YOYO)!
Re: Util [message #245251 is a reply to message #245227] Fri, 15 June 2007 11:37 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi,

I dont want to debug the procedure.It was just an example procedure. I am only trying to create a utl directory so that the user can read the file from that directory. So ,I have mentioned the procedure of what I did to create the directory.

After executing the procedure, I dont see the file in the c:\temp\utl_file directory.

please help.Thanks so much!
Re: Util [message #245252 is a reply to message #245251] Fri, 15 June 2007 11:44 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
We can't help you, because you use "wrong number or types of arguments in call to 'example'", and since we don't know how the procedure 'example' looks, and we don't even know how you called it there is absolutely nothing we can to to help you.
Re: Util [message #245253 is a reply to message #245227] Fri, 15 June 2007 11:50 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
plshelp,please check if this is what you required.
http://www.adp-gmbh.ch/ora/plsql/utl_file.html
Re: Util [message #245267 is a reply to message #245251] Fri, 15 June 2007 13:03 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
UTL_FILE reads and writes on the server, not the client.
Previous Topic: Switching UNDO tablespace
Next Topic: problems with oracle 10 on linux after reboot
Goto Forum:
  


Current Time: Fri Dec 02 12:13:53 CST 2016

Total time taken to generate the page: 0.28859 seconds