Hello All,
I am using Oracle SQL query to extract data of my interest from the Oracle database. Please advise. I am trying to use SQL Creator and SQL Executor but no luck. Please advise. Thanks
Question
Oracle Sql Query from Oracle Database to extract data
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.
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.
+13- Safer
Hi @gsgoraya what is the SQL query you are trying to run? And what is the resulting error or problem you are encountering?
@egomm is spot on for the first thing to check.
If that's not it, please post the relevant part of your log file here so we can see what the trouble is.
+8@gsgoraya, If you like, you can use an Oracle non-spatial reader to read any non-spatial table you are interested in. If you want to fetch the results of a user made query, you can use any table (I alway use the DUAL table from Oracle) and after the feature type is in the cancas, you can lookup the feature type in the Navigator pane and select Parameters and Format and Select Statement. Enter the query you wish to execute (indeed, without the semicolon) in the parameter field. In the latter case you have to put an AttributeExposer transformer in the workspace naming all columns in the query result to expose them as attributes.