Re: Help please ! MS SQL -> Oracle !

From: Geoff Reader <grr_at_NOSPAM.bton.ac.uk>
Date: Thu, 03 Jan 2002 16:34:28 +0000
Message-ID: <3C348814.194F9D68@NOSPAM.bton.ac.uk>

It may be that you have a NULL value from SQLServer that you are trying to Insert into the column on Oracle which would like a number, if you can change NULLs to zero's that would probably help.

Don't know how you'd do it in SQLServer, but in SQLPlus it would be NVL(column_name,0)

HTH
Geoff
Geoff Reader
University of Brighton

Sally wrote:
>
> Dear all,
>
> What I need is to transfer data from a SQL Server table to an Oracle table.
> I use DTS in SQL Server to simplify the process. However, the task failed.
> An error 'Invalid Number' is prompted indicates an error occurs to one
> field. The field types of the source and the destination tables are as
> follow.
>
> (SQL) numeric(18,2) --> (Oracle) number(18,2)
>
> The field types look the same but the process failed. Could any body tell
> me why and how to solve it ?
>
> Thanks for any help !
>
> Sally
Received on Thu Jan 03 2002 - 10:34:28 CST