The following table lists the Java to PL/SQL type translation performed 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