0 Replies Latest reply on Oct 15, 2018 6:59 AM by Boris Benda

    SqlDeveloper 18.3 xmltype issue ORA-22275: invalid LOB locator specified

    Boris Benda

      Hi,

       

      There might be still an issue when displaying xmltype is SqlDeveloper 18.3:

       

      For example, execute the following query:

       

      select xmlforest(first_name, last_name, email)

        from employees;

       

      and then double click in a cell of data grid.

      Sometimes it shows data in xml format, and sometimes it

      displays ORA-22275: invalid LOB locator specified.

       

      Best regards,

       

      Boris