The following table lists the Java to PL/SQL type translation performed by the PL/SQL Generator.
This Java type |
Maps to this PL/SQL type |
Notes |
Any Java array | ORA_JAVA.JARRAY |
ORA_JAVA.JARRAY
is a subtype of ORA_JAVA.JOBJECT |
boolean |
BOOLEAN |
|
byte |
PLS_INTEGER |
|
char |
PLS_INTEGER |
|
double |
NUMBER |
|
float |
NUMBER |
|
int |
NUMBER |
|
long |
NUMBER |
|
Any Java object | ORA_JAVA.JOBJECT |
|
short |
PLS_INTEGER |
|
java.lang.String |
VARCHAR2 |
|
Any Java exception | ORA_JAVA.JEXCEPTION |
ORA_JAVA.JEXCEPTION
is a subtype of ORA_JAVA.JOBJECT |
Note that Java arrays and Java objects map to special ORA_JAVA
types, ORA_JAVA.JARRAY
and ORA_JAVA.JOBJECT
. Also
note that because the Java int
and PL/SQL int
type
support is different, the Java int
maps to a PL/SQL NUMBER
type.
Finding Java Type Information in the PL/SQL Package
Working with Built-in PL/SQL Type Definitions
Copyright © 1984, 2005, Oracle. All rights reserved.