This content has been marked as final. Show 2 replies
user630376 wrote:refer below MOS notes.
I am facing this error:
SQL state ; error code ; ORA-22275: invalid LOB locator specified
; nested exception is java.sql.SQLException: ORA-22275: invalid LOB locator specified
I get this error when just trying to read data. the data is read from a view. The table that is driving table for this view has one CLOB column.
The SQL gets executed is select * from my_view and data retrieved in java.sql.Resultset.
then read from ResultSet as ResultSet .getString(my_clob_column).
The same data if imported in Oracle 11g and tried retrieving data from there; there is no error.
Master Note - RDBMS Large Objects (LOBs) [ID 1268771.1]