ORA-22275: invalid LOB locator specified

From: Mel Christie <mel_at_sensory.com>
Date: Fri, 23 Apr 1999 17:44:51 -0400
Message-ID: <nQ5U2.3984$%L2.152212_at_news6.ispnews.com>

I keep getting the above message whenever I try to add a record in Delphi 4 with Oracle 8 when the record contains a blob and the table uses a trigger. The trigger is:

create or replace trigger ADD_V1_STUDENT_DATA   before insert on V1_STUDENT_DATA for each row declare
  MyBlob1 BLOB;
  MyBlob2 BLOB;
begin

    insert into STUDENT_COURSES values (:new.ID, :new.NAME, EMPTY_BLOB())     returning COURSE_DATA into MyBlob2;

• Add Blob (Error is caused here...) MyBlob2 := :new.COURSE_DATA;
  -- select :new.COURSE_DATA into MyBlob1 from DUAL;
  
  • DBMS_LOB.COPY(MyBlob2, MyBlob1, DBMS_LOB.GETLENGTH(MyBlob1), 1, 1); end;

Neither the line "MyBlob2 := :new.COURSE_DATA" nor the DBMS_LOB line work.

Please help

regards

Mel Received on Fri Apr 23 1999 - 23:44:51 CEST