Question

Why does FME assume Oracle Database Version 10.2.0?

Userlevel 4

+13

I have Oracle Readers and Writers in my workspace and the translation successfully completes. But in the log I see this message:

Oracle database version could not be determined; assuming version of '10.2.0'

My Oracle database version is not 10.2.0. Why does FME assume this version?

Userlevel 4

+13

It’s important to mention that this message can be safely ignored. Your workspace will still successfully complete even if this message is displayed.

FME executes the following SQL statements when an Oracle Reader or Writer is used in a workspace:

SELECT * FROM V$OPTION WHERE PARAMETER = 'Spatial' AND VALUE = 'TRUE'

SELECT SDO_VERSION FROM DUAL

SELECT SDO_ADMIN.SDO_VERSION() FROM DUAL

If the results of these queries are empty, FME cannot determine the Oracle database version and will assume version 10.2.0.

Sign up