Skip to Main Content

SQL Developer

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!

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

Boris BendaOct 15 2018 — edited Oct 15 2018

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

Comments

Processing

Post Details

Added on Oct 15 2018
0 comments
365 views