DSXchange

Posted: **Mon Oct 31, 2011 4:59 am**

Hi Guys,

My source is a Flat file. The Input column sample value is 2011-07-16. I am reading it as Date.

My Target is Oracle table. This column is a part of Primary Key. I directly mapped the column. But i am getting the following error.

Code: Select all

Oracle_Connector_43,0: The OCI function OCIStmtExecute returned status 1. Error code: 1722, Error message: ORA-01722: invalid number.

I even tried to read it as Varchar and convert it to Date using StringToDate(Columnname) function. Still i am getting the following error.

Also CurrentDate() is also giving me the same error.

Can somebody guide me as what i am doing wrong.

Cheers!!!

Posted: **Mon Oct 31, 2011 7:57 am**

Hi mac4rfree85,

is the column mentioned the only column in your stream?

The error-message does not specify a column explicitly, but it complains about an 'invalid number', not a date.

Posted: **Wed Nov 02, 2011 2:59 am**

Hi,

Yeah i too saw that. But i have hardcoded 'X' for all Varchar and Char columns and 0 for Decimal. Apart from this, there is only one Date column which i guess should be the issue.
Now, even CurrentDate() column is giving the same "Invalid Number" issue.

Can somebody help me out with this.

DSXchange

Insert into Date column in Oracle

Insert into Date column in Oracle