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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityI 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?
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;
/