DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: report 6i

  1. #1
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    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?

  3. #3
    Join Date
    Oct 2000
    Posts
    123

    Smile

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

    Take care

  4. #4
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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

  5. #5
    Join Date
    Jul 2000
    Posts
    296
    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
  •  


Click Here to Expand Forum to Full Width