Oracle file spool problem

Results 1 to 2 of 2

Thread: Oracle file spool problem

  1. #1
    Join Date
    Dec 1969

    Default Oracle file spool problem

    Hi All,<BR><BR>I need to create a text file based on table output and have two problems for an Oracle 7<BR><BR>1. How do I stop the query from showing the data when running it through SQLPlus?<BR><BR>2. Why does this file not spool?<BR><BR>Code:<BR><BR>SET VERIFY OFF;<BR><BR>ACCEPT INP_CLIENT NUMBER PROMPT &#039;ENTER CLIENT CODE: &#039;;<BR><BR>SPOOL C:winntprofilesadccfh4desktop&inp_client&#124&#124 demo.LST;<BR><BR>select * from table where client_code = &INP_CLIENT;<BR><BR>SPOOL OFF;<BR><BR>CLEAR BREAKS;<BR><BR><BR>TIA<BR><BR>Bastien<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle file spool problem

    1) set termout off<BR><BR>2) Try this as a test:<BR> SPOOL C: est.txt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts