What is the max cursor size for dynamic sql?

Hi,

I am trying to use dynamic sql for a very large cursor in PL/SQL. I am getting numeric or value error when I try and parse the string holding the cursor.

Does anyone know the maximum size that the string can be for PL/SQL?

I am holding the cursor in a varchar2(8000).

Cheers
Blair

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 17 2000 - 00:00:00 CDT