Bug in PL/SQL Developer Sessions Define Session Queries.

[Rahul P]

Hi,

Version 8.0.0.1480.
I added a new 'session query' in 'sessions' tool.

The query was something like this:

SELECT SQL_TEXT, BINDS_XML, A.* FROM V$SQL_MONITOR A
WHERE a.sid = :sid
AND a.session_serial# = :serial#

So, the third column in this sql should be 'key' and so on.
But, the 'binds_xml' column is messing with the portrayal of the query. It's showing the data in the WRONG columns. Please let me know if you need more info.

Ok, modifying the post again. Looks like the CLOBs are the ones messing up the presentation. Originally I thought it was xmltype.

BTW, LOVE your IDE. The best one around.

 

[Marco Kalter]

This is indeed a known issue with CLOB columns. It will be fixed.

As a workaround you can query to_char(BINDS_XML), but this is limited to 4000 bytes.