ORA-01722 error

ajithaselvan · Post by **ajithaselvan** » Mon Mar 14, 2011 1:26 am

Hi,
I'm getting the error: ORA-01722 when i try to insert in DB using oracle connector stage. I checked all the options which were mentioned in the previous posts. I checked the input meta data with target DB metada and I'm not doing any conversions.
Below is my input

sec_num number,
sec_key varchar,
sec_type varchar,
card_no varchar,
detail varchar,
curr_dt date

Instead of giving output link to oracle connector, i gave to sequential file.
In separate job, i took that seq file as my input and tried to insert using oracle stage, I was able to insert.

I'm not able to insert straight away or not by using dataset (instead of sequential file)

Kindly help me to resolve this.

Regards,

ray.wurlod · Post by **ray.wurlod** » Mon Mar 14, 2011 2:42 am

What does error code -1722 mean?

Learn to look up Oracle error codes, maybe by using the oerr command. This will aid your diagnosis.

GJ_Stage · Post by **GJ_Stage** » Mon Mar 14, 2011 5:48 am

It is not related to DataStage error. Error with out data.

command to find error message :

oerr ora 01722

01722, 00000, "invalid number"