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.
is this u require???
SET SERVEROUT ON
CREATE OR REPLACE AND COMPILE JAVA SOURCE
public class test
public static void test (String name,int num)
int i = 1;
int s = i + num ;
String prtString="Hello Useless "+name +"...."+num;
CREATE OR REPLACE PROCEDURE test(name varchar2,i number)
AS LANGUAGE JAVA
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.
Click Here to Expand Forum to Full Width