report 6i

[pras]

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

[akkerend]

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?

[mber]

U can use read and write file package("UTL") to create files istead of "spool", this is more neat sometimes.

Take care

[pras]

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

[akkerend]

You can use the TEXT_IO built-in package to read/wrtie files from reports.