View Issue Details

IDProjectCategoryView StatusLast Update
0000044JBSQLBugspublic2017-09-20 08:20
Reporteruser8Assigned Tojorgen.bosman 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Platformx86OSWindowsOS Version7
Product Version1.3.0.2 
Target VersionFixed in Version1.3.0.3 
Summary0000044: TRIMSPOOL option doesn't work from the @ command
DescriptionThe trimspool option works perfectly when typed or copied directly after the command prompt.
Using it in a sql script file by running it from the "@"-command does not work. Other options like set heading off do work from both the command prompt and the sql file, so the prblem seems to be TRIMSPOOL specific.
Steps To Reproducecopy this sql
1 - after the prompt
2 - into a file test.sql and run @test.sql

the second test will show spaces after sysdate, the first not.

set trimspool on
set feedback on
spool d:\spooltrst.txt
select sysdate
from dual;
spool off
TagsNo tags attached.
Oracle Client Version11.2.0.1.0
Oracle Server Version11.2.0.3.0

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2014-01-07 14:03 user8 New Issue
2014-01-07 14:03 user8 Status new => assigned
2014-01-07 14:03 user8 Assigned To => jorgen.bosman
2014-01-07 19:24 jorgen.bosman Status assigned => confirmed
2014-01-07 19:25 jorgen.bosman Status confirmed => resolved
2014-01-07 19:25 jorgen.bosman Fixed in Version => 1.3.0.3
2014-01-07 19:25 jorgen.bosman Resolution open => fixed
2017-09-20 08:20 jorgen.bosman Status resolved => closed