Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: Updating Or...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 7 of 7 Topic 16548 of 17418
Post > Topic >>

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. :-)
 




 7 Posts in Topic:
Updating Oracle database from SQL Server as linked table
Garrett Fitzgerald <S  2008-05-12 13:42:07 
Re: Updating Oracle database from SQL Server as linked table
"Terry Dykstra"  2008-05-12 21:50:04 
Re: Updating Oracle database from SQL Server as linked table
Garrett Fitzgerald <S  2008-05-12 18:46:31 
Re: Updating Oracle database from SQL Server as linked table
Mladen Gogala <mgogala  2008-05-13 07:07:34 
Re: Updating Oracle database from SQL Server as linked table
Mark D Powell <Mark.Po  2008-05-13 06:49:12 
Re: Updating Oracle database from SQL Server as linked table
Mladen Gogala <mgogala  2008-05-13 22:27:32 
Re: Updating Oracle database from SQL Server as linked table
Garrett Fitzgerald <S  2008-05-14 09:15:45 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 14:59:30 CST 2008.