On Wed, 3 Mar 2010 16:10:53 +0100, "H.Merijn Brand"
<h.m.br...@xs4all.nl> 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/
