VARCHAR2 limit in PL/SQL
329230Apr 15 2003 — edited Apr 16 2003I have a stored procedure which generates code
dynamically - basically a 'SELECT ... FROM DUAL
UNION SELECT ... FROM DUAL ..... UNION SELECT ... FROM DUAL' construct -
that I use in an 'OPEN my_cursor FOR my_statement'.
It's a bit wicked but that's the way I need to do it.
(The interface must have a "IN OUT REF CURSOR"!)
Now, my problem is that I'm stuck with the 32767 bytes
limit of VARCHAR2 when constructing my_statement.
Any idea of what can be done to overcome the problem
of my_statement exceeding this 32767 limit?
I thought of using an array of VARCHAR2(32767) but
I'd like to know if there's something better.
Regards,
Yannick.