Printable View
hello everybody,
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.
thankyou
pras
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.
Take care
hello akkerend
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.
pras
You can use the TEXT_IO built-in package to read/wrtie files from reports.
