SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data type conversion issues between Oracle and SQL Server

571956Aug 22 2007 — edited Aug 22 2007

Hi there, I am using Heterogeneous Services to insert into a SQL Server database. I am running into an issue between data types regarding Oracle's VARCHAR2 and trying to insert that into a SQL Server MONEY data type. I tried using the TO_NUMBER() function to convert my VARCHAR2 to a number, but that didn't seem to help.

Does anyone have any advice on how to work around this??

Thanks for any help,
ivalum21

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2007

Added on Aug 22 2007

13 comments

2,402 views