Chapter 24. UTL_FILE Built-in Package
Beginner
Q: | |
24-1. | You must add one or more UTL_FILE_DIR entries to enable access to a specific directory. So unless you include an entry for your directory, you can’t read/write in that location. |
Q: | |
24-2. | Entries are:
By the way, I wasn’t even certain that (d) would work, so I wrote a script to test them all. If you are interested in running this test yourself, see utlfile.tst and utlfile.ora on the book’s web page. |
Q: | |
24-3. | You can use the following shorthand entry to specify that you want to read/write in any directory on the server: UTL_FILE_DIR = * This is definitely not recommended practice for any production system, since there can be serious ramifications (like writing over your database log file). It is a quick-and-dirty ... |
Get Oracle PL/SQL Programming: A Developer's Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.