SupportSupport

Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Why does DBVis strip out Oracle hints?

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 2 - Pages: 1 - Last Post: Mar 9, 2012 11:43 PM Last Post By: Ronald Rood
Robert Nicholson

Posts: 25
Registered: 08/21/08
Why does DBVis strip out Oracle hints?
Posted: Mar 9, 2012 11:11 PM
  thread.click_reply Reply
My debug in window clearly shows that DBVis is stripping off Oracle SQL Hints from the query it executes.

Why would it do that?
Hans Bergsten


Posts: 1,255
Registered: 10/11/06
Re: Why does DBVis strip out Oracle hints?
Posted: Mar 9, 2012 11:23 PM   global.in_response_to.tooltip in response to: Robert Nicholson
  thread.click_reply Reply
Hi Robert,

Prior to DbVisualizer 8.0, Oracle hints were not recognized as "special" comments and therefore stripped off if the block comment delimiters were set to the default "/*" and "*/" values.

If you can, please upgrade to 8.0 to fix this. If not, you need to change the block comment delimiters to something else in Tool Properties, SQL Editor->Comments, e.g. use "/**" as the begin delimiter.

Best Regards,
Hans
Ronald Rood

Posts: 527
Registered: 10/12/05
Re: Why does DBVis strip out Oracle hints?
Posted: Mar 9, 2012 11:43 PM   global.in_response_to.tooltip in response to: Robert Nicholson
  thread.click_reply Reply
change the block comment strings to '/* ' and '*/' Hints start with '/*+' so this makes enough differences to work.
Pages: 1
Back to Thread List Back to Thread List

Point your RSS reader here for a feed of the latest messages in all forums