| Loading data via Sql Loader into Varray Tables [message #472322] |
Thu, 19 August 2010 20:21  |
Pavan Pusuluri
Messages: 2
Registered: August 2010
Location: HYderabad India
|
Junior Member |
|
|
Hi Every body
Is it Possible doing SQL LOAD into Varray table having two inner objects. If it is not posssible could you please throw some light on why it is not possible.
Please find the structure of the table and its types for your reference
CREATE OR REPLACE TYPE OB_TEST_INFO AS OBJECT (
AGE NUMBER ( 3 ),
NAME VARCHAR2 ( 14 )
);
/
CREATE OR REPLACE TYPE OB_TEST_INFO_VARRAY AS VARRAY( 400 ) OF OB_TEST_INFO ;
/
CREATE OR REPLACE TYPE OB_TEST_MAINTENANCE AS OBJECT (
BREAKOUT_TYPE NUMBER ( 1 ),
EXISTING_STRIPS_FLAG NUMBER ( 1 ),
OB_TEST_INFO OB_TEST_INFO_VARRAY
);
/
CREATE OR REPLACE TYPE OB_TEST_MAINT_VARRAY AS VARRAY( 4 ) of OB_TEST_MAINTENANCE ;
/
CREATE TABLE VA_TEST_MAINTENANCE
(
DOMAIN_ID NUMBER ( 9 ),
USER_ID NUMBER ( 10 ),
OB_TEST_MAINT_INFO OB_TEST_MAINT_VARRAY
)
|
|
|
|
|
|
| Re: Loading data via Sql Loader into Varray Tables [message #472324 is a reply to message #472323] |
Thu, 19 August 2010 20:43  |
Pavan Pusuluri
Messages: 2
Registered: August 2010
Location: HYderabad India
|
Junior Member |
|
|
Hi
The application is designed with Varrays and nested objects.It is already running in UAT and i am afraid if we can do anything about the design.
Coming back to the issue we are trying to insert data into the Varray which is having two inner objects through SQl loader.What i would like to know hereby any means is it possible to insert the data via sql loader.
Oracle version i am using is 10.2.0.4 and the underlying OS is Windows
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
