Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> loading nulls into a varray with SQL Loader
Right I am trying to load some data using sqlldr into Oracle 9.
I have a table that contains a varray, which is declared thus: type CONS_PERIOD_VALUES as VARRAY (50) of NUMBER(13,5)
Now the thing is that I want the varray to be 'padded out' with nulls
so that it always has 50 elements, i.e. if I put 40 values in, then
there should be 10 nulls at the end.
but if I give it (where the first number is the number of elements to
follow):
50,.0076,..........0076,.0074,.0075,.0075,.0073,.0078,.0074,.0072,"","" it doesnt load it. Same as: 50,.0076,..........0076,.0074,.0075,.0075,.0073,.0078,.0074,.0072,,
And if I give it this:
48,.0076,..........0076,.0074,.0075,.0075,.0073,.0078,.0074,.0072
I only get 48 values.
So how do I put nulls in the varray????
Thannks
Received on Wed Feb 01 2006 - 08:51:40 CST