This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 8903

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: 8903

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 ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: stored procedure_array
 
Similar Threads
query for updating
stored procedure inside another stored procedure
Array as input to stored procedure.
Help with: java.sql.SQLException: ORA-01008: not all variables bound
How to pass arrays using JDBC to database?