sql plus output 3

[maswien]

why following code always output the SQL to file EDT.txt and print the resultset two times?

set linesize 200
set trimspool on
set pagesize 60
spool c:\oracle_report\EDT.txt
 
  Select...

spool off

How to fix this problem? Thanks

 

[Turkbear]

Hi,
Do you mean the output file has 2 sets of the returned data from the Select statement ?
(also, try after setting feedback off)

Can you post a sample?

 

[maswien]

I tried that, but "set feedback off" only supress " # rows selected". The results are still displayed two times.

 

[jhammer98]

Try

set echo off

This controls wheather the 'start' command lists each command in a command file as the command is executed. 'On' lists the commands and 'off' supresses the listing.

 

[SantaMufasa]

Maswien,

I'll bet that you have a semicolon at the end of your SQL query and a slash on the next line as well, true?


Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[maswien]

Set echo off, SQL Plus still output the same.

 

[jhammer98]

How about...

Set verify off

 

[SantaMufasa]

Maswien,

Did you see my question about semicolon followed by slash on the next line?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[maswien]

Musafa, you are right! that makes the results display duplicate, but I still struggle to supress the SQL.

 

[SantaMufasa]

Maswien,

Those, above, who suggest "set echo off" assert the method by which SQL*Plus suppresses scripted commands. Could you please post an exact image of your script plus the results that display on the screen, obscuring, of course any private or proprietary content?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[maswien]

script:

set linesize 200
set trimspool on
set pagesize 59
set echo off
spool c:\temp\EPT.txt
select * from application
/
spool off

following content in EPT.txt

SQL> select * from application
  2  /

APPL            dept                                     div                  name                
--------------- ---------------------------------------- -------------------- -------------------------
sdcd            fdgdfgdgdfgfgdfgdfgffff                  ytt                  fdsa         
sdsdswwdsd      fghfggggfff                              rty                   hjj                                                
ssddsd          sdddfffffffffdddddd                      fff                  gggg                    
...

93 rows selected.

SQL> spool off

 

[SantaMufasa]

Maswien,

Also to confirm...are you 1) Pasting the code onto the screen at a SQL> prompt, or 2) Invoking the script with a "@<script_name"?. I'm asking because I do not see on your copy and paste any evidence of a "@<script_name>" invocation.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[maswien]

I copied and pasted there, didn't use @scriptfile, that makes difference?

 

[maswien]

Yes Mufasa, it does make difference for me, when I run it using @scriptfile, everything looks fine, so I should do that way, thanks for the help!

 

[SantaMufasa]

Yes...that is why I bolded ...suppresses scripted commands..., because "set echo off" has an effect only when you run it from a script. I should have said, instead, "...the method by which SQL*Plus suppresses the output of commands when invoked from '@<script_name>'...".

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.