Hi
I don't know about WB but in a custom mapping file it is possible The way I do it is to the use the following syntax ORACLE8I_DEF TABNAME oracle_sql "select...." oracle_dim 2 here the SELECT statement can be any select containing functions, sub selects, inline views, joins etc. note you have to put "" around your select statement Peter Laulund National Survey and Cadastre, Denmark >From: "B�langer, David" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: "'[email protected]'" <[email protected]> >Subject: [fme] OracleQuerier >Date: Wed, 6 Apr 2005 13:08:44 -0400 > > > >Hi, >I use FME Workbench and I would like to extract geospatial data from >Oracle8i according to a nonspatial query. Is it possible to use >OracleQuerier transformer with only a "where clause" (no Spatial >Interaction) ? The "where clause" is not predefined because It is defined >during the execution of the Workbench. > >If it isn't possible, do you have an another way to do that ? > >Thanks > >David > > > > > >Get the maximum benefit from your FME, FME Objects, or SpatialDirect via >our Professional Services team. Visit www.safe.com/services for details. >Yahoo! Groups Links > > > > > > > _________________________________________________________________ Undg� pop-ups med MSN Toolbar http://toolbar.msn.dk Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. 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/
