DSXchange

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

The ASAP answer is : yes.

Hi Arnd/Kumar s,

This is urgent fror me.Thats why i said asap.

Thanks,
sudhakar

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

Hi rwierdsm ,

It is nullable column.

Thanks,
sudhakar[/i]

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.

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

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

sudhakar_viswa wrote:Hi rwierdsm ,

It is nullable column.

Thanks,
sudhakar[/i]

Check to see if the row has a null date.

sudhakar_viswa wrote:Hi Arnd/Kumar s,

This is urgent fror me.Thats why i said asap.

Thanks,
sudhakar

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.