how to read a jawa object into pl/sql stored procedure

[esreddy]

Can any one help me how to read a jawa object into a PL/SQL procedure. let me explain in detail.

I have a Vector consists of 1000 Records. Each record consists 40 fields(columns). I have to read those 40 columns in a stored procedure like

CREATE PROCEDURE PROC1 ( VAR1 NUMBBER,VAR2 NUMBER,.....) AS

within this procedure i have to insert into a table.

please try to give me a solution asap.

thank u

[balajiyes]

is this u require???

SET SERVEROUT ON
CREATE OR REPLACE AND COMPILE JAVA SOURCE
NAMED "test"
AS
import java.util.*;
public class test
{
public static void test (String name,int num)
{
int i = 1;
int s = i + num ;
System.out.println("b4"+i +"i..............num"+num);
String prtString="Hello Useless "+name +"...."+num;
System.out.println("after"+i +"i..............num"+num);
System.out.println(prtString);
}
}

/
CREATE OR REPLACE PROCEDURE test(name varchar2,i number)
AS LANGUAGE JAVA
NAME 'test.test(java.lang.String,int)';
/

CALL dbms_java.set_output(1000);
/

CALL test('jegan',10);


regards

[esreddy]

no, i think u did't get my problem exactly.
I have a Vector of 1000 records.
I have to read those records through a stored procedure and within that procedure i have to insert those records into different tables. Hope u got my problem.

thanks