Big string in SQLPlus

oracleoracle-11gsqlplus

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?

Best Answer

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;
/