Solved

Passing a table to Oracle 11g

Posted on 2008-10-14
4
1,529 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 74

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 74

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
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
This video shows how to recover a database from a user managed backup

707 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