error in oracle plugin
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
error in oracle plugin
Hi,
I am getting the following error while loading the data into Oracle.
Oracle_Enterprise_29: When checking operator: When validating export schema: At field "LEDATE": "null_field" length (10) must match field's fixed width (8)
can any one help me asap.
Thanks,
sudhakar
I am getting the following error while loading the data into Oracle.
Oracle_Enterprise_29: When checking operator: When validating export schema: At field "LEDATE": "null_field" length (10) must match field's fixed width (8)
can any one help me asap.
Thanks,
sudhakar
i need to know datastage
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
-
- Premium Member
- Posts: 209
- Joined: Fri Jan 09, 2004 1:14 pm
- Location: Toronto, Canada
- Contact:
Re: error in oracle plugin
sudhakar_viswa wrote:can any one help me asap.
Tsk, tsk, tsk, (like my sister used to say!) Sudhakar you've been around long enough to know that will earn you a tongue lashing!
Is your target field defined as not null? It message seems to be indicating that you are loading null values into a not null column.
Rob W
Rob Wierdsma
Toronto, Canada
bartonbishop.com
Toronto, Canada
bartonbishop.com
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
sudhakar_viswa, I had to answer that way to your question and would do the same next time.
Of course we understand that the problem is urgent for you, not for anyone else. But I felt that since it wasn't urgent or important enough for you to use the SEARCH facility I wouldn't expend any energy on the matter either. Had you used search you would have found several threads which answer your question.
Of course we understand that the problem is urgent for you, not for anyone else. But I felt that since it wasn't urgent or important enough for you to use the SEARCH facility I wouldn't expend any energy on the matter either. Had you used search you would have found several threads which answer your question.
-
- Participant
- Posts: 24
- Joined: Fri Aug 26, 2005 3:52 pm
- Contact:
Re: error in oracle plugin
hi sudha,
please check the Date farmat conversion is proper before moving.
Replace the dummy date when the field input is blank.
HTH
Thanks
Raghu
please check the Date farmat conversion is proper before moving.
Replace the dummy date when the field input is blank.
HTH
Thanks
Raghu
sudhakar_viswa wrote:Hi,
I am getting the following error while loading the data into Oracle.
Oracle_Enterprise_29: When checking operator: When validating export schema: At field "LEDATE": "null_field" length (10) must match field's fixed width (8)
can any one help me asap.
Thanks,
sudhakar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can sign up with your support provider for premium service. Here we don't do "urgent" or "asap"; we are all volunteers who post as and when we can, without pay. If you need "urgent" you have to pay; that's how the real world works.sudhakar_viswa wrote:Hi Arnd/Kumar s,
This is urgent fror me.Thats why i said asap.
Thanks,
sudhakar
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.