Illegal spool file name : "test.log APPEND" (bad character ' ')

Something Recognizable · Apr 12, 2022 11:54AM

Hello,

I would like to use the append option of spool but seem to not be enable to.

-----------------------------------------------------------------

Code :

SET DEFINE OFF

SPOOL test.log APPEND

SET SERVEROUTPUT ON ;

...

SPOOL OFF ;

SET DEFINE ON

SET SERVEROUTPUT OFF

---------------------------------------------------------------

Error message :

Illegal spool file name: "test.log APPEND" (bad character: ' ')

------------------------------------------------------------------

Oracle Database Version : 10g Enterprise Edition release 10.2.0.4.0

-----------------------------------------------------------------

Thank you for your help

EdStevens · Apr 13, 2022 2:19PM

But you are asking in a forum specifically for SQL Dev. Better asked in the "General Database Discussions"

User_2DKLA · Apr 12, 2022 5:32PM

Which version of SQL Developer are you using? It works as advertised in SQL Developer 21.4.3.

Regards,

Something Recognizable · Apr 13, 2022 7:36AM

I am running this in a sql script directly with SqlPlus

EdStevens · Apr 13, 2022 2:19PM

But you are asking in a forum specifically for SQL Dev. Better asked in the "General Database Discussions"

Something Recognizable · Apr 13, 2022 2:21PM

My bad I didn't see that.

Thank you

Forum Stats