Skip to main content
Question

Why does FME assume Oracle Database Version 10.2.0?

  • December 7, 2016
  • 1 reply
  • 11 views
fmelizard
Safer
Forum|alt.badge.img+21

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?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Author
  • Safer
  • 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.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.