A script-enabled browser is required for this page to function properly.

Finding Java Type Information in the PL/SQL Package

The generated PL/SQL package spec includes comments that provide Java type and signature information for the imported Java. The type and signature information in the comments is JNI-based. These comments immediately precede the PL/SQL signature for the generated item.

In this example, the following Java methods:

public void p1(char x);
public void p1(int x);
public void p1(long x);

are mapped to the following in the generated PL/SQL package:

-- Method: p1 (C)V
PROCEDURE p1 (
   obj   ORA_JAVA.JOBJECT,
   a0    PLS_INTEGER);

-- Method: p1 (I)V
PROCEDURE p1_1 (
   obj   ORA_JAVA.JOBJECT,
   a0    NUMBER);
-- Method: p1 (J)V
PROCEDURE p1_2 (
   obj   ORA_JAVA.JOBJECT,
   a0    NUMBER);

Note the comments above each generated procedure.

Comment Description
-- Method: p1 (C)V  indicates that the original Java was a method named p1 that takes a char as an argument.
-- Method: p1 (I)V  indicates that the original Java was a method named p1 that takes an int as an argument.
-- Method: p1 (J)V indicates that the original Java was a method named p1 that takes a long as an argument.