Hi Ken, A bad news error doesn't mean there is necessarily a problem - for example "BADNEWS: ... OCI_NO_DATA" might simply be an end-of-data marker (as in repeat...until EOF). That's why all rows are still being correctly returned. BADNEWS doesn't generally appear unless you turn it on - my advice is to leave it off.
As to the 'WHERE' clause, is there any other info in the log that relates to this? I'd hope for something along the lines of... reading data from Oracle using "select xxxx from yyyy where zzzz" - if the "where zzzz" is missing then FME is dropping it for some reason. If it's there then you should try running the command manually through SQLPLUS and see what it returns. If it too fails then the query must be wrong somehow. Ah - I see you are using FME Objects. Does this translation work if you simply use the regular FME workbench/command line? Hope this helps Mark Mark Ireland Product Specialist, Safe Software --- In [email protected], "kenherdy" <[EMAIL PROTECTED]> wrote: > > I have created an Oracle8I reader within FME Objects and am running > this on Solaris. > > I can open the reader and I can connect succesfully. I can also > connect using SQLPLUS and the ora8ilist script for UNIX returns the > tables in my database which contains spatial columns (SDO.GEOMETRY). > > The FME log file generated shows I am connected. However, it is also > showing errors that occur during SQL database fetches. For example, > > "BADNEWS: An error occurred while fetching from query `SELECT > SDO_VERSION FROM DUAL' : OCI_NO_DATA > (./foundation/framework/util/dbwrap/ocistmt.cpp:698)" > > For some reason, all database rows are still returned. The problem is > that when I try to restrict the rows using a WHERE clause. All rows > are still returned. I believe FME is ignoring the failed fetches and > returning all rows anyway. > > Any help here would be appreciated. > Join us at the FME Worldwide User Conference Sept. 21-22, 2006 Vancouver BC Canada. For more information, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
