Oracle SQL Developer - Spooling error

Question

I am learning SQL at the moment, and am using Oracle SQL Developer.

Right now I am having an issue with the spool command.

I insert the file path and name the file but I keep getting an "unknown command" error.

spool C:\Users\user\Desktop\AAA_Task1\output.txt
set echo on
--drop table TESTTABLE;
create table TESTTABLE (TestCol int);
set echo off
spool off

I alternate between the create and drop statements for each test.

I run the and the table is created or dropped correctly, but I get a line one error "Unknown Command" and no text file is created.

I have attached a picture of a test command and the error.

If someone could point me in the right direction I would be grateful.

Oracle SQL Developer - Spooling issue

Community · Accepted Answer · 2017-05-23 12:06:20Z

3

There is difference between run script and run statement, see here. Use following commands and run script.

spool 'C:\Users\user\Desktop\AAA_Task1\output.txt'
set echo on
--drop table TESTTABLE;
create table TESTTABLE (TestCol int);
set echo off
spool off

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Apr 1, 2015 at 21:46

Atilla Ozgur

14.8k3 gold badges54 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Walkerbo Over a year ago

Doh So I simply just needed to wrap the file path in quotation marks. I cant believe I missed that. Thank you so much for the speedy reply.

NELSON JOSEPH · Accepted Answer · 2022-11-28 21:58:42Z

0

Making the file path in quotes did not work for me in the Oracle database.

spool data.txt
set echo on
Query -- the query
set echo off
spool off

this will save the query and output to the data.txt file in the "C:\Users\NELSON JOSEPH\AppData\Roaming\SQL Developer\data.txt" in this location likewise username varies for others.

answered Nov 28, 2022 at 21:58

NELSON JOSEPH

857 bronze badges

1 Comment

NELSON JOSEPH Over a year ago

When you save the .sql file to any location after that when you run the script the spooled txt file will be in that location.

Collectives™ on Stack Overflow

Oracle SQL Developer - Spooling error

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related