Big string in SQLPlus

Question

I need to write a Select query in bind-variable and this query has more than 2500 symbols.

Variable sql_txt clob;

Exec :sql_txt := 'Select .....';

But SQL Plus support only <2499 symbols. How to fix it?

Maybe write all in a text file and execute this file with sqlplus — Wernfried Domscheit, Jan 29 '20 at 16:28

Balazs Papp · Accepted Answer · 2020-01-29 15:27:18Z

2

That limitation is for a single line.

You can break your statement into multiple lines to overcome that limitation, such as:

begin
  :sql_txt := 'select ... ' ||
  ' ... ' ||
  ...
  ' ... ';
end;
/

answered Jan 29 '20 at 15:27

Balazs Papp

35.9k2 gold badges16 silver badges39 bronze badges

I wrote the same as you. Now I want to print it in SQL Plus, but the text doesn't show, only small part of it. – Proglib Jan 29 '20 at 18:43

Add a comment |

1 Answer 1