Asp.net,SQL tips-Tricks for error resolution version 2014,2012,2008,2005,Procedural language,Stored Procedure, computer , excel macro programming,Film,Musical notations,Indian ,Western Music.

January 3, 2013

Redirect output in a file in Oracle PL SQL

There are different ways:
a) Before you execute the package you can enable SPOOL.
or
b) Create a temporary package and insert the log messages into that so that data can be viewed later on the temporary table.
or
c) Use DBMS_FILE package procedure to open and write data into files.
To Create file using PL/SQL this may be useful