[Home] [Help]
PACKAGE: SYS.DBMS_TYPES
Source
1 PACKAGE dbms_types AS
2 TYPECODE_DATE PLS_INTEGER := 12;
3 TYPECODE_NUMBER PLS_INTEGER := 2;
4 TYPECODE_RAW PLS_INTEGER := 95;
5 TYPECODE_CHAR PLS_INTEGER := 96;
6 TYPECODE_VARCHAR2 PLS_INTEGER := 9;
7 TYPECODE_VARCHAR PLS_INTEGER := 1;
8 TYPECODE_MLSLABEL PLS_INTEGER := 105;
9 TYPECODE_BLOB PLS_INTEGER := 113;
10 TYPECODE_BFILE PLS_INTEGER := 114;
11 TYPECODE_CLOB PLS_INTEGER := 112;
12 TYPECODE_CFILE PLS_INTEGER := 115;
13 TYPECODE_TIMESTAMP PLS_INTEGER := 187;
14 TYPECODE_TIMESTAMP_TZ PLS_INTEGER := 188;
15 TYPECODE_TIMESTAMP_LTZ PLS_INTEGER := 232;
16 TYPECODE_INTERVAL_YM PLS_INTEGER := 189;
17 TYPECODE_INTERVAL_DS PLS_INTEGER := 190;
18
19 TYPECODE_REF PLS_INTEGER := 110;
20 TYPECODE_OBJECT PLS_INTEGER := 108;
21 TYPECODE_VARRAY PLS_INTEGER := 247; /* COLLECTION TYPE */
22 TYPECODE_TABLE PLS_INTEGER := 248; /* COLLECTION TYPE */
23 TYPECODE_NAMEDCOLLECTION PLS_INTEGER := 122;
24 TYPECODE_OPAQUE PLS_INTEGER := 58; /* OPAQUE TYPE */
25
26 /* NOTE: These typecodes are for use in AnyData api only and are short forms
27 for the corresponding char typecodes with a charset form of SQLCS_NCHAR.
28 */
29 TYPECODE_NCHAR PLS_INTEGER := 286;
30 TYPECODE_NVARCHAR2 PLS_INTEGER := 287;
31 TYPECODE_NCLOB PLS_INTEGER := 288;
32
33 /* Typecodes for Binary Float, Binary Double and Urowid. */
34 TYPECODE_BFLOAT PLS_INTEGER := 100;
35 TYPECODE_BDOUBLE PLS_INTEGER := 101;
36 TYPECODE_UROWID PLS_INTEGER := 104;
37
38 SUCCESS PLS_INTEGER := 0;
39 NO_DATA PLS_INTEGER := 100;
40
41 /* Exceptions */
42 invalid_parameters EXCEPTION;
43 PRAGMA EXCEPTION_INIT(invalid_parameters, -22369);
44
45 incorrect_usage EXCEPTION;
46 PRAGMA EXCEPTION_INIT(incorrect_usage, -22370);
47
48 type_mismatch EXCEPTION;
49 PRAGMA EXCEPTION_INIT(type_mismatch, -22626);
50
51 END dbms_types;