Spooling script with /*insert*/ hint gives an incorrect output

User_ZZQ0F

Hello,

I am trying to use VS Code add-on to spool INSERT scripts. As instead I get the incorrect output.

When I use the same script using SQL Plus, I get the correct output containing INSERT scripts.

The code:

show serveroutput
set sqlblanklines on
set heading off
set linesize 10000
set long 90000

-- not available in VSCode
-- set ddl pretty on
-- set ddl storage on
-- set ddl segment_attributes on
-- set ddl tablespace on
-- set ddl sqlterminator on
-- set pages 999 
-- set longchunksize 1000

spool %userprofile%\Desktop\log_results.sql;
SELECT /*insert*/ * FROM CO_RDP_PROJECT where dwh_id < 0;
spool off;

It looks like the add-on is ignoring the /*insert*/ hint.

Could you please try to fix it?

Christian.Shay -Oracle

Hi,

Are you sure you got this working with SQL*Plus (and not sqlcl)? As far as I know this is a feature of SQLCl/SQL Developer and not SQL*Plus. I just tried it with SQL*Plus and it doesn't do anything other than output the rows.

We support (limited) SQL*Plus syntax with this extension although if a SQLCl enhancement is popular enough we might be able to add it.

Christian.Shay -Oracle

Hi,

Are you sure you got this working with SQL*Plus (and not sqlcl)? As far as I know this is a feature of SQLCl/SQL Developer and not SQL*Plus. I just tried it with SQL*Plus and it doesn't do anything other than output the rows.

We support (limited) SQL*Plus syntax with this extension although if a SQLCl enhancement is popular enough we might be able to add it.

User_ZZQ0F

Hello Christian,

you are right I am using SQLcl instead of SQL Plus. My mistake.

That's a great news! Cannot wait for SQLcl support, cuz I am heavily using both SQLcl and the extension at the daily basis :)

Christian.Shay -Oracle

https://community.oracle.com/tech/developers/discussion/comment/16815949#Comment_16815949

Could you please let me know which SQL*CL commands are the most important to you? Which ones you miss the most when using this extension?