SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
My procedure is shown below. When I execute it, it gives me the title error. Field3 is identified as a CLOB. Any / all help would be greatly appreciated. Running Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 CREATE OR REPLACE PROCEDURE xxx IS FileHandle SYS.UTL_FILE.FILE_TYPE; FileName VARCHAR2(2000); FileText VARCHAR2(2000); vField1 TABLE.field1%TYPE; vField2 TABLE.field2%TYPE; vField3 TABLE.field3%TYPE; [...]

Answer Question   |  January 15, 2009  3:07 PM
ORA-06502, PL/SQL, PL/SQL error messages, PL/SQL: numeric or value error