Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE questions, Urgent!!!
UTL_FILE questions, Urgent!!! [message #38727] Wed, 08 May 2002 20:23 Go to next message
wrinn
Messages: 2
Registered: May 2002
Junior Member
Hi,
I'm implementing the PL/SQL programs on 3 tiers(Middleware server (MS), Database server(DS) and Desktop) environment.
My program is in 'Middleware' server. the problem is when I use command 'UTL_FILE' to write a file into MS.
I got the error message 'UTL_FILE.INVALID_OPERATION'.
(Even I declared the required path into INIT.ora already)
Do you know why?
But when I use 'UTL_FILE' to write a file to DS instead, it completed successfully.
Is it the limitation of UTL_FILE that it can write to Database server only?

Report message to a moderator

Re: UTL_FILE questions, Urgent!!! [message #38731 is a reply to message #38727] Thu, 09 May 2002 04:08 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
if you map application server directory in database server and after setting utl_file_dir parameter, utl_file writes to middle tier server directory.

Report message to a moderator

Previous Topic: Job
Next Topic: Pushing data into Cache as fast as possible
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 17:53:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.