Execute Immediate on a very long string causes exception
Posted on 2008-10-30
The SQL is 52,028 characters without spaces and 78,960 with spaces.
I need to use execute immediate so I can define the partition for one of the tables dynamically. This is the only reason that I need the sql to execute in an execute immediate block.
ERROR at line 1:
ORA-20000: ORA-06502: PL/SQL: numeric or value error: character string buffer
ORA-06512: at line 1721