Hi,
I've installed DBD Oracle 1.20, on Solar
5.8,<http://www.nntp.perl.org/group/perl.dbi.users/2008/04/msg32777.html>
The make installed with a few bumps but the t/56embbeded was ok - which
contains the features I intend on using.
As part of my development I've created a table containing a column of VARRAY
of abstract data types.
I tried this test with a VARRAY of VARCHARS which worked no issues, however
I'd like a VARRAY of abstract data types to support my data structure.
Which makes me think this maybe required under bugs, if it's not an install
issue
Any idea's?
Here is a small test if you'd like to replicate the problem
#------------------
#Oracle DDL
#------------------
CREATE OR REPLACE TYPE BIG_BOSS as OBJECT(
name VARCHAR (9 )
);
CREATE OR REPLACE TYPE BOSSES AS VARRAY(2) OF BIG_BOSS;
DROP TABLE TEST_ORA
CREATE TABLE TEST_ORA (
heading VARCHAR(4),
boss_varray BOSSES
);
insert into TEST_ORA values ('test',
BOSSES(
BIG_BOSS('numpty'),
BIG_BOSS('dumpty')
));
#----------------------------------------------------
#Perl Code
#----------------------------------------------------
my $sql = 'select * from TEST_ORA';
my $sth = $dbh->prepare( $sql );
#----------------------------------------------------
#Perl DBD ERROR Message
#----------------------------------------------------
DBD::Oracle::db prepare failed: ORA-24334: no descriptor for this position
(DBD ERROR: OCIParamGet) [for Statement "select * from TEST_ORA"] at
./popAMAError.pl line 34.
#---------------------------------------------------
#Make test results
#---------------------------------------------------
r...@ux11 # make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/10general.............ok
t/15nls.................ok
t/20select..............ok
t/21nchar............... Database and client versions and character sets:
Database 9.2.0.8.0 CHAR set is US7ASCII (Non-Unicode), NCHAR set is
AL16UTF16 (Unicode)
Client 9.2.0.8 NLS_LANG is '<unset>', NLS_NCHAR is '<unset>'
t/21nchar...............ok
t/22nchar_al32utf8......ok
t/22nchar_utf8..........ok
t/23wide_db.............skipped
all skipped: Database character set is not Unicode
t/23wide_db_8bit........skipped
all skipped: Database character set is not Unicode
t/23wide_db_al32utf8....skipped
all skipped: Database character set is not Unicode
t/24implicit_utf8.......ok
t/25plsql...............ok 42/82(DBI::errstr undefined)
t/25plsql...............FAILED test 43
Failed 1/82 tests, 98.78% okay
t/26exe_array...........ok
t/28array_bind..........ok
t/30long................ok
122/470 skipped: various reasons
t/31lob.................ok
t/40ph_type.............ok 3/19 Placeholder behaviour for ora_type=1 (the
default) varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type.............ok
t/50cursor..............ok
t/55nested..............ok
t/56embbeded............ok
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................ok
t/80ora_charset.........ok 8/14# Failed test (t/80ora_charset.t at line
83)
# got: '?'
# expected: '°'
t/80ora_charset.........NOK 9# Failed test (t/80ora_charset.t at line
84)
# got: '?'
# expected: '°'
t/80ora_charset.........ok 12/14# Failed test (t/80ora_charset.t at line
83)
# got: '?'
# expected: '°'
t/80ora_charset.........NOK 13# Failed test (t/80ora_charset.t at line
84)
# got: '?'
# expected: '°'
t/80ora_charset.........NOK 14# Looks like you failed 4 tests of 14.
t/80ora_charset.........dubious
Test returned status 4 (wstat 1024, 0x400)
DIED. FAILED tests 9-10, 13-14
Failed 4/14 tests, 71.43% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/25plsql.t 82 1 1.22% 43
t/80ora_charset.t 4 1024 14 4 28.57% 9-10 13-14
4 tests and 122 subtests skipped.
Failed 2/23 test scripts, 91.30% okay. 5/1950 subtests failed, 99.74% okay.
*** Error code 2
make: Fatal error: Command failed for target `test_dynamic'
