• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1534
  • Last Modified:

Passing a table to Oracle 11g

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
Jeff Certain
Asked:
Jeff Certain
  • 2
  • 2
1 Solution
 
sdstuberCommented:
0
 
Jeff CertainAuthor Commented:
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
 
sdstuberCommented:
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
 
Jeff CertainAuthor Commented:
I guess the interesting question is how you pass those compound types from .NET into Oracle and vice-versa.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now