Home » Server Options » Streams & AQ » Numeric Data Conversion from Oracle to SQL Server (Oracle 10.2.0.4, Solaris 9)
icon1.gif  Numeric Data Conversion from Oracle to SQL Server [message #417646] Mon, 10 August 2009 14:19 Go to next message
dasuwal@gmail.com
Messages: 20
Registered: June 2009
Junior Member
Hi Forum

I am replicating from Oracle to SQL server with streams. There is a problem with Numeric colums.
Sql server require data with exact precision, but oracle has flexible precision. Is there any datatype available in SQL server for flexible precision.

The Cast function doesnt work in my case due to handling of some third party tools.

Please advice.

Thanks in advance,
Raj.
Re: Numeric Data Conversion from Oracle to SQL Server [message #417648 is a reply to message #417646] Mon, 10 August 2009 14:45 Go to previous message
Michel Cadot
Messages: 68711
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Is there any datatype available in SQL server for flexible precision.

Maybe this question should be posted in SQL Server forum.

Regards
Michel
Previous Topic: Oracle streams
Next Topic: Can PAYLOAD in Queues be other than OBJECT like PL/SQL table?
Goto Forum:
  


Current Time: Sat Nov 09 16:26:47 CST 2024