stored procedure_array

[raseena nm]

hi,
i wanna insert values to a table through stored procedure.
But the datas im gettiing from a java array.
Can anybody tell me how to pass an array to a stored procedure.
Thanx in advance.

[Pradeep bhatt]

You may be interested in reading about Table and Varrays in PL/SQL.

[SJ Adnams]

https://coderanch.com/t/79966/Oracle-OAS/pass-two-dimensional-Object-Array

[raseena nm]

hi pradeep,
can u just give me a URL which will provide me the needed information.
I meant about varray and table.
Thanx a lot.

[raseena nm]

hi simon,
your info waz a valuable one for me.
But i wanna do it not for one dimensional array.
anyway thanx for your guidence

[Pradeep bhatt]

http://download-west.oracle.com/docs/cd/A91202_01/901_doc/appdev.901/a89856/05_colls.htm#1059
Multi level collection
http://download-west.oracle.com/docs/cd/A91202_01/901_doc/appdev.901/a89856/05_colls.htm#33814
[ December 10, 2003: Message edited by: Pradeep Bhat ]