I checked the fields and they are the SQL defined types. I also ran the query at my Oracle Client and it works perfect. Do you think it might be a problem in pluging in Oracle with DS.
Don't think its anything with the plugin... Got to do with the ODBC oracle driver you have setup for DS. Lookup the manual for the driver you have installed and whether it supports the datatypes and the length or precision you are trying to select.
Are you trying to view from DS Manager or from a Designer job? You should try from a Designer job and use the get SQL info button.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
I have been trying to looup for data at the manager. I tried looking at data at the server and found out that it was asking for a password to connect to the database.