?
Solved

Passing a table to Oracle 11g

Posted on 2008-10-14
4
Medium Priority
?
1,530 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 1500 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

Setting up LaraDock for Laravel

Learn how to set up LaraDock in a Laravel project - LaraDock gives us an easy way to run a Laravel application using Docker in a single command.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
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 video shows how to recover a database from a user managed backup
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

771 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