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.

Report message to a moderator

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: 68348
Registered: March 2007
Location: Nanterre, France, http://...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 05 00:39:51 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.