| Util [message #245227] |
Fri, 15 June 2007 10:31  |
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  |
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 #245243 is a reply to message #245227] |
Fri, 15 June 2007 11:24 |
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 #245251 is a reply to message #245227] |
Fri, 15 June 2007 11:37 |
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 |
ThomasG
Messages: 3212
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
