-
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
-
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
Cheers!
OraKid.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|