My Oracle Support Banner

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 APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.11.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
  


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