SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Execute Immediate and CLOB

Vishal R.Apr 12 2010 — edited May 6 2010

Hi All,

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

I am getting error when trying to use CLOB with execute immediate.

DECLARE

v_clob CLOB;

BEGIN

EXECUTE IMMEDIATE 'SELECT DBMS_METADATA.GET_DDL(''TABLE'',''T_FDB_TMP'') from dual'
           INTO v_clob_part_ddl; 

EXECUTE IMMEDIATE 'DROP TABLE T_FDB_TMP';

EXECUTE IMMEDIATE to_char(v_clob_part_ddl);

END;


ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 1
ORA-06502: PL/SQL: numeric or value error
ORA-31605: the following was returned from LpxXSLResetAllVars in routine kuxslResetParams:
LPX-1: NULL pointer
ORA-06512: at line 3
06502. 00000 -  "PL/SQL: numeric or value error%s"

Please help

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2010

Added on Apr 12 2010

5 comments

2,296 views