2 Replies Latest reply: Apr 17, 2013 11:58 PM by KR10822864 RSS

    Error: ORA-22275: invalid LOB locator spec

    user630376
      Hello All,

      I am facing this error:
      SQL state [99999]; error code [22275]; 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.

      Any suggestions?

      Thanks in advance.
        • 1. Re: Error: ORA-22275: invalid LOB locator spec
          TSharma-Oracle
          .

          Edited by: TSharma on Apr 16, 2013 3:35 PM
          • 2. Re: Error: ORA-22275: invalid LOB locator spec
            KR10822864
            user630376 wrote:
            Hello All,

            I am facing this error:
            SQL state [99999]; error code [22275]; 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.

            Any suggestions?
            refer below MOS notes.
            Master Note - RDBMS Large Objects (LOBs) [ID 1268771.1]