OLEDB 10.2.0.1: Executing SQL Containing Double Hyphen ("--") As Remark Throw Errors (Doc ID 728806.1)

Last updated on SEPTEMBER 28, 2010

Applies to:

Oracle Provider for OLE DB - Version: 10.2.0.1.0 to 10.2.0.4 - Release: to 10.2
Microsoft Windows (32-bit)

Symptoms

Using Oracle OLE DB Provider 10.2.0.1 and executing SQL containing double hyphen ("--") for remark like

SELECT 1 --A REMARK
FROM DUAL

does not work while C/SQL like comment "/* */"

SELECT 1 /* REMARK */
FROM DUAL

works

.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms