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
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