| Load Data into Oracle DataBase from Excel in a single hit. [message #457293] |
Sun, 23 May 2010 03:21  |
oraranjangmailcom
Messages: 67
Registered: April 2010
|
Member |
|
|
Hi,
In an Excel sheet there are many blocks of Data and each block has a separate table in oracle database.
By using .net, planning to send all the blocks of data into an array and then to oracle stored procedure/package.
By using collections, I know how to load one block of data into one table(one at a time), but I am not sure how to load multiple blocks of data into one variable and then load to multiple tables.
Example:
Excel sheet has two blocks - emp & dept
emp:- 40 records, 10 fields in excel sheet
dept:- 40 records, 5 fields in excel sheet
DataBase has two tables - emp $ dept
emp:- 10 columns
dept:- 5 columns
From Excel sheet in an array both the emp and dept data.
How to hold the both tables data in an variable(oracle stored procedure), even if I am able to hold(procedure inparameter) then how to distinguish b/w tables and load according into tables.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
