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. __.____._ | _.____.__ |
No comments:
Post a Comment