I am using sqlcl in a bespoke ci/cd setup and one of my scripts uses ords_export.export_module to get the module source code out of the database.
When this scripts saves the output (spool) of the command it leaves me with incorrect line breaks on longer lines so my automated process no longer works.
This is my export script:
set termout off
set heading off
set pagesize 0
set linesize 0
set long 100000
set longchunksize 100000
set trimout on
set trimspool on
set feedback off
set echo off
set sqlformat default
spool &1..sql;
select 'set define off;' from dual;
select ords_export.export_module('&2') from dual;
select '/' from dual;
select 'exit;' from dual;
spool off;
exit;
Is this a bug or am I doing something wrong?