passing a numeric array back from an Oracle function

[DavidCroft]

I'm currently replacing Access code with Oracle back end procedures/functions. One of the functions as written in Access returns a numeric array - if I want to do the same thing in Oracle, is it possible - if so, what do I return from the Oracle function?

 

[sem]

You may use collections:
varrays, pl/sql or nested tables.

 

[KarthikBala]

I want to pass varriant datatype from ASP to VB then VB Component passing this varriant to Oracle8i Package.
(e.g)(The data like
('Product_Id','P_short_NM',
'P1_Value','P2_Value')

Can any one help me out for this issue.

Karthik Bala