Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    6

    Unanswered: Passing an multi array to sql from java over jdbc

    Hi Guys,

    I am fairly new to PL and I am trying to solve this problem.

    I need to pass a two dimensional array(A variable Name and Variable value) to a stored procedure in PL/SQL. I dont want to pass this data as a big string..I was hoping to passing it as an array because it would be easier to handle the data.

    Basically I would be calling this procedure from a java program over JDBC.

    My question is how do I create this...

    Since I would be filling this from Java, it would be a parameter within the procedure something like

    CREATE OR REPLACE PROCEDURE Test_Response ( pisa_response Varchar[][] )

    Of course Varchar[][] is not supported by PL but just showed this to give more understanding of the problem


    Any help on this would be really appreciated..


    Thanks in advance..

    Regards,
    Freakie

  2. #2
    Join Date
    Aug 2003
    Posts
    40
    Check the thread in the Java section of this "dbForums" for details.

  3. #3
    Join Date
    Dec 2003
    Posts
    6
    Hi Thanks 4 the reply...

    From what I gathered.. I might need to send it as a string...but I do not want to do that...

    I basically want to send it as an array of strings... I am not sure whether using ORacle.sql.array feature might help?????

    Regards,
    Freakie

  4. #4
    Join Date
    Aug 2003
    Posts
    40
    Again, check the thread in the Java section of this forums. Its got
    complete code to perform what your looking for, so long as your
    running Oracle 9i.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •