Command Window handles TRIMSPOOL SQL*PLUS command very badly

[Bernhard S]

I have a SQL*Plus script which runs fine in SQL*Plus, containing a

set trimspool on

. When I execute the same script in a PL/SQL Developer Command Window, I get

Cannot SET TRIMSPOOL

and the query that is supposed to get spooled won't generate any output in the spoolfile! I think PL/SQL Developer should be able to at least tolerate all the possible SQL*Plus commands and not fail queries if one of those is used in a script.
Otherwise you're forced to write different scripts for PL/SQL Developer and SQL*Plus, which really sucks!

 

[Marco Kalter]

To enable spooling you need to execute the SPOOL command. The SET TRIMSPOOL command is indeed not supported.

 

[Bernhard S]

I did enable spooling, but with the SET TRIMSPOOL command it wouldn't spool anything in PL/SQL Developer Command Window. It would only spool the query output if I leave out SET TRIMSPOOL command.