Solved

Passing a table to Oracle 11g

Posted on 2008-10-14
4
1,526 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

806 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