10-12-07, 09:05 #1Registered User
- Join Date
- Oct 2007
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
if (pID<=0) then
Insert into pages(ID,Contents) values(1, pText);
update pages set Contents=pText where ID=pID;
the above coding working fine with ORACLE 9i, same giving error in 10g
ORA-22922 Nonexcisting CLOB.....
pls help me out in this
10-12-07, 11:23 #2Registered User
Provided Answers: 1Code:
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
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.You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.