Loading data into a VARRAY [message #2114] |
Fri, 21 June 2002 05:03 |
Mark Grimshaw
Messages: 73 Registered: June 2002
|
Member |
|
|
hello,
I am having difficulty with the syntax for loading into a VARRAY column type of a table whose element type is of a NUMBER. The length of the VARRAY is 5.
Any help would be appreciated.
|
|
|
|
Re: Loading data into a VARRAY [message #2135 is a reply to message #2116] |
Mon, 24 June 2002 01:37 |
Mark Grimshaw
Messages: 73 Registered: June 2002
|
Member |
|
|
Thanks Mahesh,
Maybe I should go into even more detail with my question. My data is in the following form and I don't have any control over its format :-(
To take your example table but with the VARRAY in the middle of two fields.
Input file format: -
cp.haddock 111 222 333 555 66 anothertextfield
whoami 3 5 4 0 0 anothertextfield
As you can see the fields are separated by a space but the lengths of each field and each record in the data file are fixed which is helpful. However, after much experimentation I can't seem to get the data to load correctly.
TYIA
Mark
|
|
|
Re: Loading data into a VARRAY [message #2138 is a reply to message #2116] |
Mon, 24 June 2002 02:45 |
Mark Grimshaw
Messages: 73 Registered: June 2002
|
Member |
|
|
Thanks Mahesh,
Maybe I should go into even more detail with my question. My data is in the following form and I don't have any control over its format :-(
To take your example table but with the VARRAY in the middle of two fields.
Input file format: -
cp.haddock 111 222 333 555 66 anothertextfield
whoami 3 5 4 0 0 anothertextfield
As you can see the fields are separated by a space but the lengths of each field and each record in the data file are fixed which is helpful. However, after much experimentation I can't seem to get the data to load correctly.
TYIA
Mark
|
|
|