This content has been marked as final. Show 2 replies
This error with the plain open bracket is commonly indicating a NLS issue.
Unfortunately you didn't indicate which ODBC Driver manager and ODBC driver you are using nor on which platform you installed the gateway, so I can only guess...
Could you please add to your gateway config file the 2 gateway parameters, then retry the select in a new SQL*Plus session:
HS_NLS_NCHAR = UCS2