Array « stored procedure « Java Database Q&A





1. Optimal number of records in an Array passed to a Stored Procedure    coderanch.com

Hi all, We are intending to create a new application a prerequisite of which will be writing a lot of old data to the database from csv files. At the moment i am testing writing this data using stored procedures/CallableStatement rather than JDBC Statements. I have set up a record datatype and an array type that holds a number of these ...

2. Stored Procedures and arrays    coderanch.com

Hi all, I have written a Java stored procedure which i am using to insert information into my database. I have created an SQL user defined object that holds the details of one piece of information to be inserted. I have then created an SQL user defined array which holds a number of the user defined objects. From my Java code ...

3. Passing Array as a parameter to Stored procedures    coderanch.com

I know how to pass array as a parameter to stored procedure.. But when I did, I'm getting the error message... I have written a Oracle stored procedure. That procedure takes an array as Input parameter. Here is the syntax : Package Header PACKAGE test IS TYPE tab_arr IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER; PROCEDURE prc_ins (p_arr IN tab_arr); END ...

4. Stored Procedure - Array    coderanch.com

5. Array as input to stored procedure.    coderanch.com

I was researching this myself recently, and found the resources suggested by Avi in a previous thread here useful. This describes using the oracle ArrayDescriptor and ARRAY classes to call stored procedures with an oracle collection parameter. Note you actually need to create a type in your schema for the parameter in order to call it from JDBC. This isn't a ...

6. Pass Array From to Java to Stored Procedure    coderanch.com

Oracle database version you are using = Oracle9i Java version you are using = jdk 1.4 JDBC driver (and version) you are using = thin driver I have declared an array of numbers in package. TYPE NUM_ARRAY is TABLE OF NUMBER; TYPE DOOUBLE_ARRAY is TABLE OF NUMBER; I have written following stored procedure and it is receiving above array as a ...

7. Passing Array to Stored Procedure    coderanch.com

8. weblogic database controls + stored procedure with Array issue    coderanch.com

I have the following code in a weblogic custom control which calls the database control GetLoadProfileFrmDB.getLoadProfileData(params) which in turn calls the SP {call PKG_IWAVE_UI.PP_IWAVE_DATA_MAIN(?, ?)}. The SP takes an integer as input and gives an Array as output. But I keep getting the error when the SP executes: .getLoadProfileData(); Failure=java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of ...