Error running rel853.sql ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (act
Has anyone experienced errors when running the PeopleTools rel85X.sql scripts? The error occurs on the declare curosrs
CREATE TABLE PSYPSACTIVIMG (ACTIVITYNAME VARCHAR2(30) NOT NULL,
SEQNO SMALLINT NOT NULL,
PSIMAGEVER INTEGER NOT NULL,
IMGSEG LONG RAW)
TABLESPACE PSIMAGE2 STORAGE (INITIAL 40000 NEXT 100000
MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PCTUSED 80
;
DECLARE
CURSOR TEMP_CURSOR IS SELECT *
FROM PSACTIVIMG
;
P TEMP_CURSOR%ROWTYPE
;
BEGIN
OPEN TEMP_CURSOR
;
LOOP
FETCH TEMP_CURSOR INTO P
;
EXIT WHEN TEMP_CURSOR%NOTFOUND
;
INSERT INTO PSYPSACTIVIMG (
ACTIVITYNAME,
SEQNO,
PSIMAGEVER,
IMGSEG)
VALUES(
P.ACTIVITYNAME,
P.SEQNO,
P.PSIMAGEVER,
P.IMGSEG
)
;
COMMIT
;
END LOOP
;
CLOSE TEMP_CURSOR
;
END
;