Re: Updating Oracle database from SQL Server as linked table
by Garrett Fitzgerald <SarekOfVulcan@[EMAIL PROTECTED]
>
May 14, 2008 at 09:15 AM
On May 13, 9:49=A0am, Mark D Powell <Mark.Pow...@[EMAIL PROTECTED]
> wrote:
> If may also be possible to get around the ODBC error via the use of an
> explict convert function in the code or if that does not work by
> placing a view over the Oracle table that incudes the necessary
> conversion. =A0I think I have managed to work around one or two errors
> using the above.
Mark, thanks: I created a view on the relevant fields, casting Number
to Number(16), and it worked like a charm.
Thanks to everyone else who chimed in as well: I appreciate the
assistance. :-)