Solved

Passing a table to Oracle 11g

Posted on 2008-10-14
4
1,524 Views
Last Modified: 2013-11-11
One of the cool new features in SQL Server 2008 is the ability to pass in a table-valued parameter.

Passing a one-dimensional array into Oracle 11g isn't terribly challenging. However, I've heard a rumor that it is possible to pass a full-blown table into Oracle 11g from .NET code.

I'm looking for a definitive answer on this on -- either a link to authoritative proof that it can't be done, or .NET code that proves that it can.
0
Comment
Question by:Jeff Certain
  • 2
  • 2
4 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 22727981
0
 
LVL 24

Author Comment

by:Jeff Certain
ID: 22728019
That looks a lot like it's 4 separate one-dimensional arrays passed into Oracle. While this will do the job, I was sort of hoping it was possible to pass an actual table (or a multidimensional array with variable types -- without using Object).
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 22728071
there's not really a good correlation in oracle to a multi-dimensional array.

You can have associative arrays of compound types instead of scalar ones though.

so, instead of creating 4 arrays for the pieces ofthe jobs table, you could instead have a single array (table in oracle syntax) of the entire jobs structure.


type t_job is table of jobs%rowtype index by pls_integer;
0
 
LVL 24

Author Comment

by:Jeff Certain
ID: 22736154
I guess the interesting question is how you pass those compound types from .NET into Oracle and vice-versa.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now