Skip to main content
Question

Why does FME assume Oracle Database Version 10.2.0?

  • December 7, 2016
  • 1 reply
  • 7 views

fmelizard
Contributor
Forum|alt.badge.img+17

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?

1 reply

fmelizard
Contributor
Forum|alt.badge.img+17
  • Author
  • Contributor
  • December 7, 2016

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.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings