Hi Dont use the WB but write a mapping file in stead, her you can defien a oracle table as select complety avoiding the spatial query, join many tables, or write any sql you want, I also think you could execute a pl/sql progam via the BEGIN_SQL syntax but I have not tested this.
To Michael, there is a special oracel tcl package - oratcl. I use this to acces oracle rather than the odbc package, this I use to get data ind and out off access, dbf etc. Peter Laulund National Survey and Cadastre, Denmark >From: Michael Habarta <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: Re: [fme] Sql select query >Date: Thu, 17 Nov 2005 23:51:04 +0100 > >Hallo > >I tried a bit SQL querying on Oracle but found SQLExecutor too limited. >Coming from a traditional procedural programming environment, I still >have a hard time to get things done as I was used to. Feel like >handicapped ... > >What I did then, was to write a transformer using TCL and accessing >ORACLE directly over ODBC connection. In that way I could do more >on SQL level. > >It is quite useful for specialized tasks, but not very flexible ... >and in many ways not really fitting to the FME philosophy ... > >Recently I need to access ArcSDE versioned tables and tried >ArcSDEQuerier which gives even more headache ... > >So I am searching in this area too ... > >Michael > > >intelecgeomatic wrote: > > Hi, > > > > I use FME Workbench and I would like to extract geospatial data from > > Oracle9i according to a nonspatial query. > > > > I have one spatial table and some non spatial tables, all related to > > each others. I would like to use a select query on many non spatial > > tables to extract a subset of my spatial table. > > > > I tryed something with SQLExecutor but it takes too much time to > > process. > > > > Any ideas ? > > > > Thanks > > > > > > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > >-- > // \\ Michael Habarta: Munich/Bavaria/Germany > // \\ Mail office: <mailto:[EMAIL PROTECTED]> > //=======\\ Mail priv: <mailto:[EMAIL PROTECTED]> > // \/| | \\ Homepage: <http://people.freenet.de/mhabarta> > // | | \\ Motto: Romans 8:28 > > > > >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 > > > > > > _________________________________________________________________ Del din verden med MSN Spaces http://spaces.msn.com 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/
