Hi Richard, That's OK. In fact the developer was obviously watching the user group and fixed the problem without me even having to notify or hassle him (the best kind of fix in my view!) So I just closed the support ticket directly and will let you know via the group.
Usually if something used to work, but doesn't after you've upgraded then it's a problem we need to know about. Of course, sometimes it's because the data has also changed in the meantime, so if you can do, try running it in the older build again to make sure it stills work there. Regards, Mark --- In [email protected], "Richard Wilkinson" <[EMAIL PROTECTED]> wrote: > > Hi Mark, > > Thanks for the feedback. On your suggestion I mailed my report to > support. I would have done so in the first instance but I wasn't that > confident that it was FME. It wouldn't be the first time I'd done > something daft! > > Regards > > Richard Wilkinson > Systems Analyst > Resources - ICT Services > Leicestershire County Council > 0116 2657709 > [EMAIL PROTECTED] > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf > Of mark2atsafe > Sent: 07 May 2007 23:01 > To: [email protected] > Subject: [fme] Re: Bug Report - Writing VARCHAR2 to Oracle DB > > > > 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] <mailto:support%40safe.com> > http://www.safe.com <http://www.safe.com> > Solutions for Spatial Data Translation, Distribution and Access > > --- In [email protected] <mailto:fme%40yahoogroups.com> , > "Richard Wilkinson" <RWilkinson@> 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 > > rwilkinson@ > > > > > > __________________________________________________________ > > 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/
