i want to create a spool file from my reports. i have already tried srw.do_SQL ('spool and filename') but this does not creates a spool file. any help please. its urgent ? spool is a command and anybody can tell me how to execute a command from reports at sql prompt.
Spool is a SQL*Plus command, not a SQL command.
SRW.DO_SQL executes SQL statements, not SQL*Plus commands.
But why do want reports to spool a file?
U can use read and write file package("UTL") to create files istead of "spool", this is more neat sometimes.
We are working on report conversion and my client has a report which automatically grants and revokes the privildges of the user. he also want a spool file to be generated.
You can use the TEXT_IO built-in package to read/wrtie files from reports.