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