[oracle-l] fetching long variable in PL/SQL

Hi all ,=20

   I have a problem about fetching long variable in PL/SQL.    I encountered with problem in following PL/SQL block.    When I try to fetch long variable , I receive " PL/SQL: numeric or = value error ORA-06512".

   As I searched in metalink, it is releated to size of long variable. = Probably it is greather than=20

   32KB.
   I could not find a solution.
   Do you have any info or and advice that how I can fetch long = variables greather than 32KB.

   May it can be divided into more than one variable but how. Thanks
Arslan.

DECLARE=20
  =20
 USER_TRIGGERS_COUNT NUMBER :=3D 0;
 USER_TRIGGERS_COUNTER NUMBER :=3D 0;
=20

 CURSOR USER_TRIGGERS_CUR IS
 SELECT TRIGGER_NAME ,DESCRIPTION , trigger_BODY FROM USER_TRIGGERS  where trigger_name =3D 'TRG_APPL_CONTRACTS_BIUD_R' ;  USER_TRIGGERS_R USER_TRIGGERS_CUR%ROWTYPE;
=20

BEGIN
select COUNT(*) INTO USER_TRIGGERS_COUNT from USER_OBJECTS WHERE = OBJECT_TYPE =3D 'TRIGGER'; =20
  OPEN USER_TRIGGERS_CUR;
  LOOP
  FETCH USER_TRIGGERS_CUR INTO l_TRIGGER_NAME ,l_DESCRIPTION ,l_BODY ;   EXIT WHEN(USER_TRIGGERS_CUR%NOTFOUND ); NULL;
  END LOOP;
  CLOSE USER_TRIGGERS_CUR;
END; Received on Sun Jan 25 2004 - 09:17:17 CST