search

laurenz / oracle_fdw

PostgreSQL Foreign Data Wrapper for Oracle
http://laurenz.github.io/oracle_fdw/
Other
496 stars 156 forks source link

Is there any way can i select ST_GEOMETRY type (ESRI ArcSDE) from oracle #695

Closed alloclhdwcy closed 4 months ago

alloclhdwcy commented 4 months ago

Hi laurenz,

I tried the way from 311:

CREATE FOREIGN TABLE transftest20240717 ( FEATID text, SHAPE geometry ) SERVER oradb OPTIONS(schema 'SZSW_GIS_SDE',table '(SELECT FEATID, SDO_GEOMETRY(SDE.ST_asText(SHAPE)) AS SHAPE FROM TEST20240717)');

But i get the following error:

ERROR: error describing remote table: OCIStmtExecute failed to describe table DETAIL: ORA-00903: invalid table name

Please help how to solve this problem ant Is there any way can i select ST_GEOMETRY type (ESRI ArcSDE).

laurenz commented 4 months ago

This is a duplicate of #678.

As documented: if you define a foreign table based on a query, you must not specify a schema.

alloclhdwcy commented 4 months ago

I'm very sorry and thank you for your time!

laurenz commented 4 months ago

No problem at all; you are welcome.