Search code examples
sqlplsqlsqlplusspoolutl-file

Write to a file in PL/SQL without spools or utl_file


Trying to create an output file through a procedure but am unable to modify the init.ora to allow for utl_file_dir or create directory. Is there another way to accomplish this without creating a table and doing a simple spool, this unfortunately, is out the question, too.


Solution

  • No. You will need access to init.ora to get this done the nice way through Oracle.

    The only other option I can think of is the use of a Java procedure to do the file writing. I couldn't find any special requirements you need to have set to use that. Read up on the subject here.