[Bhaskara]

HI All,


I am facing problem while inserting/ updating a column with CLOB Datatype @ Oracle 10g
contents --- CLOB Datatype field
PText is as clob variable, value is passing from Java application

Create or replace procedure INSERT_PAGE(pID IN int, pText IN CLOB) AS
Begin
if (pID<=0) then
Insert into pages(ID,Contents) values(1, pText);
else
update pages set Contents=pText where ID=pID;
End;
commit;
end;

the above coding working fine with ORACLE 9i, same giving error in 10g


ERROR

ORA-22922 Nonexcisting CLOB.....



pls help me out in this


with regards
Bhaskara

[anacedent]

22922, 00000, "nonexistent LOB value"
//  *Cause:  The LOB value associated with the input locator does not exist.
//           The information in the locator does not refer to an existing LOB.
//  *Action: Repopulate the locator by issuing a select statement and retry 
//           the operation.