PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Error running rel853.sql ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (act

edited May 3, 2016 5:08AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

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

;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center