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,
ORA-01722 error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
ORA-01722 error
Ajitha S
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: