Hi Richard, I didn't even need to file a PR over this - your email was passed on to one of our developers who reproduced the problem and made a fix. I'll let you know when it's available, but it will definitely be in the final release of FME2007.
Regards, Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "Richard Wilkinson" <[EMAIL PROTECTED]> wrote: > > Hi, > > I have just encountered a problem with what was a working transform that > has stopped working after I downloaded the latest build of FME. Seems > like a bug to me but I would appreciate any comments from others who may > have also seen this. > > The error is `ORA-01461: can bind a LONG value only for insert into a > LONG column' > > Occurrs when writing a varchar2 field in oracle database if and only if > the length exceeds 3998 bytes. > > <<Varchar2Test.log>> <<Varchar2Test.fmw>> > > The attached transform, Varchar2Test.fmw, is an extract from my live > production environment to illustrate the problem. > FME 2007 build 4333 is OK > FME 2007 build 4364 fails with error above. > > Regards > > 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. > 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/
