Oracle Database Discussions

Anyone,

I am still fighting with this cursor procedure I need that will select a large number of columns from a table. I am getting the following error when I run the procedure:

ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "OWNER.CUR_EXP_1", line 25
ORA-06512: at line 1

No I can eliminate the error by shrinking down the column list in my select statement (number of bytes per row).

Where is the parameter on the server I can set so that the ROW being cached in this cursor can be larger?

Thanks for anyhelp,
Miller


Here is full code so you can see what I am doing:
CREATE OR REPLACE PROCEDURE MAXIMO.cur_exp_1 IS
CURSOR c1 IS
SELECT EQNUM ,
PARENT,
SERIALNUM,
ASSETNUM,
EQ7,
EQ8,
EQ9,
EQ10,
DESCRIPTION
FROM MAXPRO_EQUIPMENT@MAXDEV_LK WHERE EQNUM = '150072';
TYPE rec_type IS RECORD ( VAR_EQNUM EQUIPMENT.EQNUM%TYPE,
VAR_PARENT EQUIPMENT.PARENT%TYPE,
VAR_SERIALNUM EQUIPMENT.SERIALNUM%TYPE,
VAR_ASSETNUM EQUIPMENT.ASSETNUM%TYPE,
VAR_EQ7 EQUIPMENT.EQ7%TYPE,
VAR_EQ8 EQUIPMENT.EQ8%TYPE,
VAR_EQ9 EQUIPMENT.EQ9%TYPE,
VAR_EQ10 EQUIPMENT.EQ10%TYPE,
VAR_DESCRIPTION EQUIPMENT.DESCRIPTION%TYPE); rec rec_type;
BEGIN
OPEN c1;
LOOP
FETCH c1 INTO rec;
EXIT WHEN c1%NOTFOUND;
/*DBMS_OUTPUT.PUT_LINE(rec.VAR_EQNUM);*/
END LOOP;
CLOSE c1;
END;