wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes How to pass a two dimensional Object Array To a Stored Procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "How to pass a two dimensional Object Array To a Stored Procedure" Watch "How to pass a two dimensional Object Array To a Stored Procedure" New topic
Author

How to pass a two dimensional Object Array To a Stored Procedure

Parthiban Sreenivasan
Greenhorn

Joined: Oct 23, 2002
Posts: 1
Hai All
I have a requirment to Pass a two dimensional object array from java to a oracle Stored procedure/Function. I am not able to handle this in the java side and also if you have some special datatype in oracle to then pls do help me that too
Pls do mail me if you have suggestions or example codes or any information on this .
Email parthiban_s@infy.com


Regards<br />S.Parthiban
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
Here is the pl/sql:

Here is the java:

here is the output:

Hope it helps.
[ October 23, 2002: Message edited by: Simon Lee ]
[ October 23, 2002: Message edited by: Simon Lee ]
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
sorry that example was for a single dimension array. However you should be able to see how to extend the example to a 2D array.
Simon
Wang Alix
Greenhorn

Joined: Oct 30, 2002
Posts: 1
can u divide a 2D array to both 1D arrays?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to pass a two dimensional Object Array To a Stored Procedure
 
Similar Threads
Pass hashtable to PL/SQL procedure
stored procedure_array
Passing VARRAYS to Java
Passing array to CallableStatement
Stored procdure return multi dimensional array?