Error using dynamic sql.

From: Nicodemus Chan <nicodemus_at_pacific.net.sg>
Date: Fri, 15 Jan 1999 11:07:38 +0800
Message-ID: <77mb54$5m3$1@newton3.pacific.net.sg>

SQLWKS> execute generate.myproc(436)

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_OUTPUT", line 64
ORA-06512: at "SCOTT.GENERATE", line 347
ORA-06512: at line 2

I am getting this error when I call my dbms_sql.parse function with my statement:

DBMS_SQL.PARSE(cur, v_statement, dbms_sql.native);

The length of v_statement is 3069 characters.

Half the time I don't get this error, even when the the length of v_statemetnt is longer like 4000+ characters.

When I output the statement and copy paste it into SQL worksheet to be executed, it executes perfectly well.

Nico. Received on Thu Jan 14 1999 - 21:07:38 CST