How can I get the value of a second parameter from a Java Class? This Example from the documentation works.

public class Invoice
{
  public static boolean testOut( int[] param )
  {
    param[0] = 123;
    return true;
  }
}
CREATE PROCEDURE testOut( OUT p INTEGER )
EXTERNAL NAME 'Invoice.testOut([I)Z'
LANGUAGE JAVA;

What I'm looking for is something like this:

public static boolean testOut( int[] param )
  {
    param[0] = 123;
    **param[1] = 444;**
    return true;
  }

I'm stuck with the declaration of the Procedure. Thanks!

asked 20 Mar '13, 03:57

Arndt's gravatar image

Arndt
21113
accept rate: 0%

edited 20 Mar '13, 08:35

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297


You cannot do what you want with JAVA stored procedures. If you look at the procedure declaration, there are two parts - the SQL wrapper definition and the JAVA signature. In your example, the SQL wrapper is:

testOut( Out p INTEGER )

and the JAVA signature is:

Invoice.testOut([I)Z

The problem is that there is no way to declare an array of OUT SQL integers in the SQL wrapper portion. You will therefore have to do something like:

CREATE PROCEDURE testOutMany( OUT p0 INTEGER, OUT p1 INTEGER, OUT p2 INTEGER )
EXTERNAL NAME 'Invoice.testOutMany([I[I[I)Z'
LANGUAGE JAVA

public static boolean testOutMany(int[] param0, int[] param1, int[] param2 )
{
    param0[0] = 123;
    param1[0] = 444;
    param2[0] = 567;
    return true;
}
permanent link

answered 20 Mar '13, 08:47

Karim%20Khamis's gravatar image

Karim Khamis
5.7k53870
accept rate: 40%

edited 20 Mar '13, 08:58

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×125
×78
×24

question asked: 20 Mar '13, 03:57

question was seen: 1,957 times

last updated: 20 Mar '13, 08:58