A few days ago, My developer encounted a problem when he develop a procedure. He met a dynamic select sql statement more than 32K.
I try to use dbms_sql package to solve this problem.
However, this brings new problems.
Our procedure used to develop as the following ways.
procedure DRP_RPT_SALES_QTY_ALL_MULTI
(
o_cursor_rst
out
ref
cursor
) is
begin
open o_cursor_rst for
'select * from dual';
end;
Now, I do not know how to achieve the same results when I use dbms_sql package instead execute immediate sql statement.
Plz help me.
Thanks.