Hi,everyone， i'm using the PL/SQL Developer 7.1.4.1390 and confront a tiny problem when i use funtion of session management(Tools -> Session..). I want to capture what kind of SQLs my application issued when i operate on it, but i got SQL texts with incomplete form, which means PL/SQL Developer return me incomplete SQL texts like "SELECT DIRCTIONARY.* FROM DIRCTIONARY WHERE (TYPE = " rather than complete ones. I think it may be the default limit for display. Could you tell me how to get the complete SQL texts? Thanks a lot!
display problem about sql capture
- Thread starter hyqgod
- Start date
This limitation comes from the Oracle view v$open_cursor. The sql_text column of this view is limited.
The complete text of the current SQL statement can be viewed on the "SQL Text" tab page, which uses the v$sqltext_with_newlines view.
The complete text of the current SQL statement can be viewed on the "SQL Text" tab page, which uses the v$sqltext_with_newlines view.
Similar threads
- Discussion
