Unable To Select Data From External Table, Containing Column Named "COMMENT" (Doc ID 2120144.1)

Last updated on JULY 12, 2017

Applies to:

Siebel Tools - Version 8.2.2.14 [IP2014] and later
Information in this document applies to any platform.

Symptoms

Unable to select data from external table, containing column named "COMMENT".

While getting data from an external table, if a column named "COMMENT" is present in the select query, an error occurs.
COMMENT is a reserved word in Oracle.

DBCLog DBCLogError 1 0000000356ea18ac:0 2016-03-17 18:30:58 OCIStmtExecute: SELECT /*+ ALL_ROWS */
  T1.CREATED,
  T1.CONTACT,
  T1.ID,
  T1.CARD,
  T1.COMMENT,
  T1.USER_AGENT,
  T1.USER_IP,
  T1.NEED_ANSWER,
  T1.OPINION_TYPE,
  T1.REGION,
  T1.NAME,
  :1
  FROM
  MALINASITE.FEEDBACK_OPINION T1
  WHERE
  (T1.ID = :2)

ObjMgrLog Error 1 0000000356ea18ac:0 2016-03-17 18:30:58 (oracon.cpp (3899)) SBL-DBC-00105: An error has occurred executing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.

SQLParseAndExecute Execute 5 0000000356ea18ac:0 2016-03-17 18:30:58 ORA-01747: invalid user.table.column, table.column, or column specification
 

ERROR
-----------------------


SBL-DBC-00105: An error has occurred executing a Sql statement.


ORA-01747: invalid user.table.column, table.column, or column specification

 

Changes

 

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