Hi Gunter You can use the oratcl libary to access oracle behind the back off fme, and this way check for the existens of the table
for some more info about the oratcl check: http://www.fmepedia.com/index.php/Pre_and_Post_Processing_Scripts:_Example_7 http://wiki.tcl.tk/ Peter >From: "gunter_nt" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: [fme] stopping the creation of a table in oracle >Date: Fri, 06 Jul 2007 05:48:34 -0000 > >Hi, >I have a tcl script which 'generates' the fme file for loading TAB >files into oracle Spatial. The idea is for us to have a 'generic' >loader for uploading any TAB file to oracle. >This is working ok, but I would like to disable FME's default >behaviour of creating an oracle table (and indexes) if one does not >exist. >Is there a argument/ MACRO I can pass to the oracle writer to get it >to fail if the table does not exist? >Basically, if the table exists, upload the data. If the table does >not exist, fail or at least output a warning message. > >Also.. if the table does exist, is there a way to stop it attempting >to create indexes? > >Thanks >Gunter > > _________________________________________________________________ Log på MSN Messenger direkte på nettet http://webmessenger.msn.com/ For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Love FME? Then open your diary to March 6-7, 2008 and write this... "Second Worldwide FME User Conference - Must Attend!" See http://www.safe.com/company/fmeuc2008/index.php for more details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
