File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes stored procedure_array Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "stored procedure_array" Watch "stored procedure_array" New topic
Author

stored procedure_array

raseena nm
Greenhorn

Joined: Nov 07, 2003
Posts: 25
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
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

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


Groovy
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
http://www.coderanch.com/t/79966/Oracle-OAS/pass-two-dimensional-Object-Array
raseena nm
Greenhorn

Joined: Nov 07, 2003
Posts: 25
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
Greenhorn

Joined: Nov 07, 2003
Posts: 25
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
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

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 ]
 
jQuery in Action, 2nd edition
 
subject: stored procedure_array