Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> loading nulls into a varray with SQL Loader

loading nulls into a varray with SQL Loader

From: Kevin <kevinherring_at_lycos.co.uk>
Date: 1 Feb 2006 06:51:40 -0800
Message-ID: <1138805500.127537.67960@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US