Re: invalid nibbles with loader

In article <1996May10.141144.199_at_v6610.ci.sj.ca.us>,

   cllndc_at_ci.sj.ca.us (cameron cleland) wrote:
>I get the following error mesage on some of my records when I try to
>load them into Oracle. I can't see anything obviously wrong with the
>data.. What could be happening?
>
>Record 490: Rejected - Error on table CONTRACT.
>ORA-01488: invalid nibble or byte in the input data

nibbles occur in packed decimal input data because it's a string of 4-bit digits. the packed format places a sign value in the last nibble: its value must be hex C or D. the other nibbles in a packed dec field must be 0 thru 9. you can get into trouble if you xmitted a file of packed dec fields from another computer in ascii rather han binary mode.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.