-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|