PL/SQL Type | Supported External Types | Default External Type |
BINARY_INTEGER, | CHAR, UNSIGNED CHAR, SHORT, | INT, |
BOOLEAN | UNSIGNED SHORT, INT | |
PLS_INTEGER | UNSIGNED INT, LONG, UNSIGNED LONG,SB1,UB1, SB2,UB2, SB4, UB4, SIZE_T | |
NATURAL | CHAR, UNSIGNED CHAR, SHORT, | UNSIGNED INT, |
NATURALN, | UNSIGNED SHORT, INT, | LONG, |
POSITIVE, | UNSIGNED INT,LONG | |
POSITIVEN, | UNSIGNED LONG, SB1, UB1, SB2 | |
SIGNTYPE | UB2, SB4, UB4, SIZE_T | |
FLOAT, REAL | FLOAT | FLOAT |
DOUBLE PRECISION | DOUBLE | DOUBLE |
CHAR, CHARACTER LONG, ROWID, VARCHAR, VARCHAR2 | STRING | STRING |
LONG RAW, RAW | RAW | RAW |
BFILE, BLOB, CLOB | OCILOBLOCATOR | OCILOBLOCATOR |