Question mark treated as bind variable within comments

Using DbVisualizer 9.0.6 and Oracle 10.2.0.4, if I "save" a function or procedure which has a comment containing a question mark, the question mark is replaced with ":1",or ":2", etc.. For example, if the following lines occur in a procedure: --This is a single-line comment containing a question mark? /* This is a block comment containing a question mark? */ These lines are "saved" as: --This is a single-line comment containing a question mark:1 /* This is a block comment containing a question mark:2 */ While I see the use in converting the question marks to the positional notation, this should not occur for question marks that are within a comment. If the question mark is in either single-quotes or double-quotes, then it is not changed. (Incidentally, this forum's text editor does not seem to allow text to be formatted with a fixed-width font.) Thank you, --Jason Boyer

Hi Jason, This is an issue in the JDBC driver. It is fixed in the Oracle JDBC driver version 11.2. Unfortunately, the 11.2 driver introduced other problems related to XML data. From the driver info page: http://www.dbvis.com/doc/oracle-database-drivers/ *Note: We've discovered a problem starting with version 11.2 of the Oracle JDBC driver whereas XML data appear as "opaque" in DbVisualizer. Until we find a permanent solution, use the 11.1 driver version.* Please be aware of this before you upgrade the driver. Best Regards, Hans