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

Java to PL/SQL Type Mapping: Quick Reference Table

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