Re: [oracle-db-l] Text File is Not Created By UTL_FILE Procedure

Reply from Sayan090886 on Apr 16 at 4:49 PM You need to have Oracle client install on your machine for that. Otherwise you login to server where your oracle is installed and then go to sqlplus and run the procedure and give any server path. The text file will be created ---------------Original Message--------------- From: Don Biddle Sent: Monday, April 16, 2012 11:37 AM Subject: Text File is Not Created By UTL_FILE Procedure The package UTL_FILE references directories/files on the database server side not the client side. In order for the client side to see the files created by UTL_FILE there must be a shared area that both the database side and client side can see. UTL_FILE.FOPEN references an Oracle Directory not a specific directory path. You need to first create an Oracle Directory. Don   Reply to this email to post your response.   __.____._ Manage Settings | Unsubscribe | Create FAQ | Send Feedback    Copyright © 2012 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251

Sayan090886   MR   Mark as helpful View this online Ask a new question   In the Spotlight Toolbox.com for iPhone & Android: Ask Questions & Get Answers Anywhere. Download the Free App _.____.__