ORA-28500 [Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 1:10 Invalid column reference (Doc ID 2800762.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

1.SQL> desc "<user>"."<table>"@DBLINK;

Name Null? Type

----------------------------------------- -------- ----------------------------

<table>.<column> VARCHAR2(255)

In describe we can seen column name showing with tablename.

2.select * from "<user>"."<table>"@DBLINK;

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

[Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement:

FAILED: SemanticException [Error 10002]: Line 1:10 Invalid column reference 'table.column' {42000,NativeErr = 80}

Changes

1.SQL> desc "<user>"."<table>"@DBLINK;

Name Null? Type

----------------------------------------- -------- ----------------------------

<table>.<column> VARCHAR2(255)

In describe we can seen column name showing with tablename.

2.select * from "<user>"."<table>"@DBLINK;

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

[Cloudera][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement:

FAILED: SemanticException [Error 10002]: Line 1:10 Invalid column reference 'table.column' {42000,NativeErr = 80}

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.