how to read a jawa object into pl/sql stored procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44

    Angry

    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

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    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.

  3. #3
    Join Date
    Oct 2001
    Location
    Hyderabad
    Posts
    44
    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
  •  



Click Here to Expand Forum to Full Width