Hi Richard If the Begin_sql directive is not working, you could take a look at the oratcl extension to tcl (http://wiki.tcl.tk/204) it allowes you to access oracel and do all kind off stuff behind the 'back' off fme
I use for logging the result off a translation, deleting tabels after a translation, getting values I then put into my mapping files as macroe's etc. I also think there is an exampel on the fmepedia under FME_END_TCL Peter >From: "Richard Wilkinson" <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: <[email protected]> >Subject: [fme] Calling an Oracle Stored procedure >Date: Mon, 13 Nov 2006 15:42:20 -0000 > >Hi, > >A similar question to this was posted last year but no solutions were >posted. > >I want to call an Oracle Stored procedure from my transform that will >execute before the transform starts. I have tried including the >statement [exec Proj.MyTest] in the SQL Statement to execute before but >I get no errors/warnings and the statement does not seem to work. > >Can anyone confirm that this should work and what the correct syntax is. >Can this be achieved another way? > >Thanks > >Richard Wilkinson >Systems Analyst >Resources - ICT Services >Leicestershire County Council >0116 2657709 >[EMAIL PROTECTED] > > >_______________________________________________________________________ >Leicestershire County Council - rated a 'four-star' council by the Audit >Commission >_______________________________________________________________________ > > >This e-mail and any files transmitted with it are confidential. If you are >not the intended recipient, any reading, printing, storage, disclosure, >copying or any other action taken in respect of this e-mail is prohibited >and may be unlawful. If you are not the intended recipient, please notify >the sender immediately by using the reply function and then permanently >delete what you have received. > >Incoming and outgoing e-mail messages are routinely monitored for >compliance with Leicestershire County Council's policy on the use of >electronic communications. The contents of e-mails may have to be >disclosed to a request under the Data Protection Act 1998 and the Freedom >of Information Act 2000. > >The views expressed by the author may not necessarily reflect the views or >policies of the Leicestershire County Council. > >Attachments to e-mail messages may contain viruses that may damage your >system. Whilst Leicestershire County Council has taken every reasonable >precaution to minimise this risk, we cannot accept any liability for any >damage which you sustain as a result of these factors. You are advised to >carry out your own virus checks before opening any attachment. > > _________________________________________________________________ Få de bedste søgeresultater med MSN Search: http://search.msn.dk 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. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. 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/
