ORA-01722 error
Posted: 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,
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,