Crash with XMLDATA.extract

[jschmied]

Hi!

The following Statement crashes the PLSQL-Developer:

SELECT cy.xmldata,
xmltype.createxml(cy.xmldata).extract('/RESPONSE')
FROM billing b

cy.xmldata is a clob column.

No debuglog is written.

Thanks

J

 

[Marco Kalter]

What is the nature of the crash (any error messages)?

 

[jschmied]

Hi!

The PLSQL Developer just closes without any message boxes. No log is written.

juergen

 

[jschmied]

PS:

xmltype.createxml(cy.xmldata).extract('/RESPONSE') gives a xmltype back.

xmltype.createxml(cy.xmldata).extract('/RESPONSE').getStringVal()
works.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.