1 Reply Latest reply: May 8, 2013 6:28 AM by Mkirtley-Oracle RSS

    ClobtoBlob:ORA-06502: PL/SQL: numeric or value error: hex to raw conversion

    user427605 - oracle
      Hi gurus,
      I met an very strange question when migrating from SQL Server to Oracle.
      There is a blob column named Imagedata in table KnowledgeBasePackage.
      In pre_load.sql,we see this line as following:
      ALTER TABLE KnowledgeBasePackage add (SQLDEVELOPER_CLOB_12 CLOB);
      Then the SQL*loader load original data into SQLDEVELOPER_CLOB_12 column.
      But when we execute procedure to convert the clob to blob as following,it failed.
      BEGIN CLOBTOBLOB_sqldeveloper('KnowledgeBasePackage', 'SQLDEVELOPER_CLOB_12', 'Imagedata'); END;
      /
      Errors:
      ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
      ORA-06512: 在 "DATA.CLOBTOBLOB_SQLDEVELOPER", line 79

      Executing this procedure on all other tables with Blob columns is successful.

      Could you please give me some hint?
      Thanks very much.
      Ling