Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-22275: invalid LOB locator specified

Status
Not open for further replies.

Vinni

Programmer
Aug 14, 2002
11
US
Guys,

I am calling a stored procedure to insert a clob datatype. The procedure declaration is:

--------------
PROCEDURE SP_UPDATE_ST_TEXT(
c1 IN OUT cv_types.genCurType,
textId in pea_ST_text.text_id%TYPE,
STguideId in pea_content.STguide_id%TYPE,
contentText in clob,
contentId in pea_content.content_id%TYPE,
editor in pea_ST_text.updated_by%TYPE)
IS
pea_id number;
blah varchar2(200);
BEGIN



IF textId = 0 THEN

-- get a new content_id from the sequence
select SEQ_PEA_ST_TEXT.NEXTVAL into pea_id from dual;

-- insert into pea_ST_text
INSERT INTO pea_ST_text (text_id, STguide_id, created, updated, updated_by, text)
VALUES (pea_id, STguideId, SYSDATE, SYSDATE, editor, contentText);

INSERT INTO pea_content_dtl (content_detail_id, content_id, detail_ptr) VALUES
(SEQ_PEA_CONTENT_DTL.NEXTVAL, contentId, pea_id);

ELSE

-- update pea_ST
UPDATE pea_ST_text SET updated = SYSDATE, updated_by = editor, text = contentText WHERE
text_id = textId;


END IF;

open c1 for
select content_id from pea_content where content_id = pea_id;

COMMIT;

END;

--------------

I get following message when I call it from my pages:

Database error: SQL call failed.
Error num : 5
VendorError1 : 22275
VendorMessage1:
VendorError2 : 1
VendorMessage2: ORA-22275: invalid LOB locator specified
ORA-06512: at "SP_UPDATE_ST_TEXT", line 21
ORA-06512: at line 1

---------------
I did a search on the web and it says 'the LOB locator was never initialized'

I don't know how to do that ?

Thanks for your help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top