Kevin wrote:
> 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
Nulls into a VARRAY? Nulls into a fixed sized array perhaps.
What is the business case?
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Feb 01 2006 - 12:10:47 CST
