Re: column_info () vs type_info ()
"H.Merijn Brand" <[email protected]>
| Newsgroups | gmane.comp.lang.perl.modules.dbi.sybase.devel |
|---|---|
| Message-ID | <[email protected]> |
On Wed, 3 Mar 2010 16:10:53 +0100, "H.Merijn Brand" <[email protected]> wrote: > DBD::Oracle does not support column_info () As Martin kindly pointed me out that column_info () *does* work in Oracle, but you need to spell out the table and fieldname in capitals. Oracle-- This database doesn't seem to support mlslabel and xmltype. Either that or I misread the Oracle allowed types documentation. Still, also Oracle presents me an interesting table of differences Oracle bfile ? -9114 BFILE -4 blob ? 30 BLOB 30 char CHAR 1 CHAR 1 char (19) CHAR 1 CHAR 1 clob ? 40 CLOB 40 date DATE 93 DATE 93 float DOUBLE PRECISION 8 FLOAT 8 float (12) DOUBLE PRECISION 8 FLOAT 8 integer DECIMAL 3 NUMBER 3 interval day to second ? 110 INTERVAL DAY(2) TO SECOND(6) 110 interval day (3) to second (2) ? 110 INTERVAL DAY(3) TO SECOND(2) 110 long LONG -1 LONG -1 long raw LONG RAW -4 LONG RAW -4 Field 1 has an Oracle type (106) which is not explicitly supported at /pro/lib/perl5/site_perl/5.10.0/i686-linux-64int/DBD/Oracle.pm line 276, <DATA> line 255. DBD::Oracle::st execute failed: ORA-00932: inconsistent datatypes: expected NUMBER got LABEL (DBD ERROR: error possibly near <*> indicator at char 7 in 'select <*>* from xbb where 0 = 1') [for Statement "select * from xbb where 0 = 1"] at /pro/lib/perl5/site_perl/5.10.0/i686-linux-64int/PROCURA/DBD.pm line 421, <DATA> line 255. mlslabel ? -9106 MLSLABEL -9106 nchar CHAR 1 NCHAR 1 nchar (13) CHAR 1 NCHAR 1 nclob ? 40 NCLOB 40 number DOUBLE PRECISION 8 NUMBER 8 number (8) DECIMAL 3 NUMBER 3 number (15, 2) DECIMAL 3 NUMBER 3 number (9, -2) DECIMAL 3 NUMBER 3 nvarchar2 (3) VARCHAR2 12 NVARCHAR2 12 raw (58) ? -2 RAW -3 rowid ? -9104 ROWID -9104 timestamp DATE 93 TIMESTAMP(6) 93 timestamp (3) DATE 93 TIMESTAMP(3) 93 urowid ? -9104 UROWID -9104 varchar (46) VARCHAR2 12 VARCHAR2 12 varchar2 (46) VARCHAR2 12 VARCHAR2 12 DBD::Oracle::db prepare failed: ORA-22318: input type is not an array type (DBD ERROR: OCIAttrGet) [for Statement "select * from xbb where 0 = 1"] at /pro/lib/perl5/site_perl/5.10.0/i686-linux-64int/PROCURA/DBD.pm line 408, <DATA> line 255. Can't call method "execute" on an undefined value at /pro/lib/perl5/site_perl/5.10.0/i686-linux-64int/PROCURA/DBD.pm line 421, <DATA> line 255. -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00, 11.11, 11.23, and 11.31, OpenSuSE 10.3, 11.0, and 11.1, AIX 5.2 and 5.3. http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/