Article

ORA-22922: nonexistent LOB value" error when selecting a clob value in an Index-Organized Table with a date column in the primary key

« Go Back

Information

 
Environment
Question/Problem Description
An "ORA-22922: nonexistent LOB value" error is received when selecting a clob value in an Index-Organized Table with a date column in the primary key.
Clarifying Information
Steps to Reproduce:
  • Create the following table:
    create table class1H001 (bbr_object_name varchar2(230) NOT NULL, bbr_value_date date NOT NULL,faststringtype3 clob NULL, constraint class1P001 primary key(bbr_value_date, bbr_object_name))organization index PCTTHRESHOLD 10 overflow
     
  • Populate table:
    insert into class1H001 values ('object1', to_date('2008-07-28 10:30:00','YYYY-MM-DD HH24:MI:SS'), 'fast')
     
  • Run the next statement:
    select* from class1H001
Error Message[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-22922: nonexistent LOB value
Defect/Enhancement NumberDD00040941
Cause
Resolution
Reproduced the issue with build 5.30.0.126. 
Defect DD00040941 has been fixed in build 5.30.0.127. 

Click here for instructions on how to download and install the patch.
Workaround
Notes
Attachment 
Feedback
 
Was this article helpful?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful.



Characters Remaining: 255

 



Copyright © 1993-2014. Progress Software Corporation. All Rights Reserved.
Previous MonthNext Month
SunMonTueWedThuFriSat