Members   Search   Help    Register    Login   Home
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: 17
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: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: Mon Nov 30 22:49:17 CST 2009

Total time taken to generate the page: 0.73835 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.