SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Passing array as a argument in the Stored Procedure/Function

657653Sep 2 2008 — edited Sep 5 2008

Hello Friends,

I need a help, i Want one stored proedure/Function which take array as a argument and return an array also.
and the size of array should not be fixed.

I don't want to use Varray because for this I have to specified its size first.

I think Associative arry will work( For dynamic size) but I am not able to run it .

Is Associative arry(Index by Pls_Integer) support JDBC?
If yes, plz give me some clue. I have found some information of associative array in this url
http://www.oracle.com/technology/oramag/oracle/07-jan/o17odp.html
But I am not able to run this package through SQL and also not able to connect it through JDBC.

Is there any other alternative solution?

Thanks & Regards,
manish Kumar

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2008

Added on Sep 2 2008

9 comments

1,386 views