Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

LOB Error on Clob datatype

IQNov 24 2015 — edited Nov 25 2015

Hello

I am using XML syntax to store values within a clob datatype of a table. This value is returned back to a page in Apex, however when I do this, I get an error which states "ORA-22275: invalid LOB locator specified".

I have checked everything but still cannot resolve this error , please advise. I am using Oracle Database version 11.2.0.1.0

ORA-22275: invalid LOB locator specified

is_internal_error: false

  • ora_sqlcode: -22275
  • ora_sqlerrm: ORA-22275: invalid LOB locator specified

Thanks

IQ

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2015
Added on Nov 24 2015
26 comments
5,091 views