Returning ResultSet from Oracle Stored procedure

[Kunwar Gadhok]

Iam calling Oracle Stored Procedures from Visual Basic.
I want to return the resultset for which Iam trying to use PL/SQL tables and now when I call the Stored Procedure and give that PL/SQL table as parameter
it says to Declare the variable(table).
Now how do I send this parameter to PL/SQL procedure.
Please Reply ASAP.

[Cimperiali]

I've solved this thanks to an article in MSDN.
Search for Q176086 in msdn. If you need more informations, let me know an e-mail address and I will send you a zipped prj you may use as an example.

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, Bruno Paris and all the other wonderful people who made and make Codeguru a great place. Come back soon, you Gurus.