Hi Oliver, thanks for your help! I was on Xmas-holidays in between and only got to read your message quite now. Well, yes I was able retrieve a seqence value such a way. But the problem was to do this once for the whole mapping process and nevertheless add this constant value to each individual feature.
Finally I ended with building a before-insert-trigger retrieving one sequence-number for the transaction and another trigger for adding the value to each individual feature. And in the end I think using oracle trigger is more appropriate (and supposedly faster) than let FME do this. Happy New Year! Christine ----- Original Message ----- From: "olivier.gayte" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, December 16, 2004 10:53 AM Subject: Re: [fme] Oracle Sequences > Hi Christine, > > I already used fme to access to an oracle sequence with SQLEXECUTOR and it > works. > You will find attached a sample extracted from a fmw file. > > Let me know I you have a problem with it. > > Regards > ________________________ > Olivier Gayte > Veremes > http://www.veremes.com > 42 av. des Jardins > 66240 St Esteve > FRANCE > T�l : + 33 (0) 4-68-38-65-27 > Fax : + 33 (0) 1-73-72-98-58 > Mobile : +33 (0) 6-60-49-83-81 > [EMAIL PROTECTED] > ________________________ > > > ----- Original Message ----- > From: "Andrae" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, December 14, 2004 1:11 PM > Subject: [fme] Oracle Sequences > > > > > > > > Hi , > > is there any way to retrieve the current Value of an Oracle Sequence as a > > constant in a workbench file? > > I would like to retrieve a sequence number from my database for each > import > > event (not for each feature) which I would like to concatenate with a > > feature attribute. > > I tried the SQL-Executor with "select mysequence.currval from dual;" but > the > > Transformer remains invalid (red button). > > > > Is there such a possibility? > > > > Christine Andrae > > Regionalverband Ruhr > > Kronprinzenstr. 35 > > 45128 Essen > > Tel. 0201-2069-236 > > email [EMAIL PROTECTED] > > > > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > 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 > > > > > 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/
