# Transfer this to Oracle.pm

# The type_info_all function was automatically generated by
# DBI::DBD::Metadata::write_typeinfo v.

package DBD::Oracle::db;         # This line can be removed once transferred.

    sub type_info_all
    {
        my ($dbh) = @_;
        require DBD::Oracle::TypeInfo;
        return $DBD::Oracle::TypeInfo::type_info_all;
    }

# Transfer this to lib/DBD/Oracle/TypeInfo.pm.
# Don't forget to add version and intellectual property control information.

# The %type_info_all hash was automatically generated by
# DBI::DBD::Metadata::write_typeinfo v.

package DBD::Oracle::TypeInfo;

{
    require Exporter;
    require DynaLoader;
    @ISA = qw(Exporter DynaLoader);
    @EXPORT = qw(type_info_all);
    use DBI (:sql_types);

    $type_info_all = [
        {
            TYPE_NAME          =>  0,
            DATA_TYPE          =>  1,
            COLUMN_SIZE        =>  2,
            LITERAL_PREFIX     =>  3,
            LITERAL_SUFFIX     =>  4,
            CREATE_PARAMS      =>  5,
            NULLABLE           =>  6,
            CASE_SENSITIVE     =>  7,
            SEARCHABLE         =>  8,
            UNSIGNED_ATTRIBUTE =>  9,
            FIXED_PREC_SCALE   => 10,
            AUTO_UNIQUE_VALUE  => 11,
            LOCAL_TYPE_NAME    => 12,
            MINIMUM_SCALE      => 13,
            MAXIMUM_SCALE      => 14,
            SQL_DATA_TYPE      => 15,
            SQL_DATETIME_SUB   => 16,
            NUM_PREC_RADIX     => 17,
            INTERVAL_PRECISION => 18,
        },
        [ "BLOB",            SQL_LONGVARBINARY, 2147483647,"'",  "'",  undef,            1,1,0,undef,0,undef,"BLOB",            undef,undef,SQL_LONGVARBINARY,undef,undef,undef, ],
        [ "LONG RAW",        SQL_LONGVARBINARY, 2147483647,"'",  "'",  undef,            1,0,0,undef,0,undef,"LONG RAW",        undef,undef,SQL_LONGVARBINARY,undef,undef,undef, ],
        [ "BFILE",           SQL_LONGVARBINARY, 2147483647,"'",  "'",  undef,            1,1,0,undef,0,undef,"BFILE",           undef,undef,SQL_LONGVARBINARY,undef,undef,undef, ],
        [ "RAW",             SQL_VARBINARY,     2000,      "'",  "'",  "max length",     1,0,3,undef,0,undef,"RAW",             undef,undef,SQL_VARBINARY,    undef,undef,undef, ],
        [ "CLOB",            SQL_LONGVARCHAR,   2147483647,"'",  "'",  undef,            1,1,0,undef,0,undef,"CLOB",            undef,undef,SQL_LONGVARCHAR,  undef,undef,undef, ],
        [ "LONG",            SQL_LONGVARCHAR,   2147483647,"'",  "'",  undef,            1,1,0,undef,0,undef,"LONG",            undef,undef,SQL_LONGVARCHAR,  undef,undef,undef, ],
        [ "CHAR",            SQL_CHAR,          2000,      "'",  "'",  "max length",     1,1,3,undef,0,0,    "CHAR",            undef,undef,SQL_CHAR,         undef,undef,undef, ],
        [ "DECIMAL",         SQL_DECIMAL,       38,        undef,undef,"precision,scale",1,0,3,0,    0,0,    "DECIMAL",         0,    38,   SQL_DECIMAL,      undef,10,   undef, ],
        [ "DOUBLE PRECISION",SQL_DOUBLE,        15,        undef,undef,undef,            1,0,3,0,    0,0,    "DOUBLE PRECISION",undef,undef,SQL_DOUBLE,       undef,10,   undef, ],
        [ "DATE",            SQL_TYPE_TIMESTAMP,19,        "'",  "'",  undef,            1,0,3,undef,0,0,    "DATE",            0,    0,    SQL_DATE,         3,    undef,undef, ],
        [ "VARCHAR2",        SQL_VARCHAR,       4000,      "'",  "'",  "max length",     1,1,3,undef,0,0,    "VARCHAR2",        undef,undef,SQL_VARCHAR,      undef,undef,undef, ],
    ];

    1;
}

__END__