I (and others) have seen various problems in using DBI-1.15 and
DBD-Oracle-1.06. The only way I could find to solve the segfaults was to
downgrade to DBI-1.14. All you would have to do is compile and install.
I was having trouble with retrieving record sets from Oracle (getting
segfaults instead).
If you need any assistance, please feel free to email me. I'll be glad to
help.
PS: I have contacted Tim Bunce about this issue, in hopes he can enlighten
me furthur.
-Original Message-
From: Tuanjai Sampannon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 2:48 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: DBI-1.15 and DBD-Oracle-1.06 (2nd)
Dear reader,
I am trying to setup the following:
- Perl 5.6.1
- Tk 800.022
- DBI-1.15
- DBD-Oracle-1.06
- Oracle8i Enterprise Edition Release 8.1.6.0.0
On Intel Solaris 8...
To my knowledge these are the latest versions available...
I am getting to DBD and there to make test, and then it fails...
To be precise: I am getting core dumps while doing the tests...
If I ignore these and do 'make install', than I can connect to the database,
and retrieve some data, but I get a core dump at the end anyway...
Please, I am a newbie to Perl, please help me! What am I doing wrong???
I am compiling Perl and DBD with the same compiler...
I have set ORACLE_SID, ORACLE_HOME, LD_LIBRARY_PATH, LD_RUN_PATH...
I can connect with Oracle using SLQ*Plus...
What am I doing wrong??? I am desperate!!!
With kind regards,
Roland Slegers
[EMAIL PROTECTED]
==
make test TEST_VERBOSE=1
==
PERL_DL_NONLAZY=1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.6.1/i86pc-sola
ris -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness qw(runtests
$verbose); $verbose=1; runtests @ARGV;' t/*.t
t/base..dubious
Test returned status 0 (wstat 139, 0x8b)
test program seems to have generated a core
t/general...1..16
ok 1
ok 2
dubious
Test returned status 0 (wstat 139, 0x8b)
test program seems to have generated a core
DIED. FAILED tests 3-16
Failed 14/16 tests, 12.50% okay
t/long..create table dbd_ora__drop_me ( idx integer, lng LONG,
dt date )
1..140
long_data0 length 10240
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng LONG, dt date )
--- insert some LONG data
ok 1
ok 2
ok 3
ok 4
--- fetch LONG data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
--- fetch LONG data back again -- truncated - LongTruncOk == 0
LongReadLen 81910, LongTruncOk
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
--- fetch LONG data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
--- fetch LONG data back again -- via blob_read
Skipped blob_read tests for LONGs with OCI8 - not currently supported.
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
long_data0 length 20480
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng LONG RAW, dt date )
--- insert some LONG RAW data
ok 36
ok 37
ok 38
ok 39
--- fetch LONG RAW data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
--- fetch LONG RAW data back again -- truncated - LongTruncOk == 0
LongReadLen 40955, LongTruncOk
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
--- fetch LONG RAW data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
--- fetch LONG RAW data back again -- via blob_read
Skipped blob_read tests for LONGs with OCI8 - not currently supported.
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70
long_data0 length 10240
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng CLOB, dt date )
--- insert some CLOB data
ok 71
ok 72
ok 73
ok 74
--- fetch CLOB data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 75
ok 76
ok 77
ok 78
ok 79
ok 80
--- fetch CLOB data back again -- truncated - LongTruncOk == 0
LongReadLen 81910, LongTruncOk
ok 81
ok 82
ok 83
ok 84
ok 85
ok 86
--- fetch CLOB data back again -- complete - LongTruncOk == 0
LongReadLen 82920, LongTruncOk
ok 87
ok 88
ok 89
ok 90
ok 91
ok 92
ok 93
ok 94
--- fetch CLOB data back again -- via blob_read
ok 95
ok 96
ok 97
ok 98
ok 99
ok 100
ok 101
ok 102
ok 103
ok 104
ok 105
long_data0 length 10240
long_data1 length 81920
long_data2 length 71680
create table dbd_ora__drop_me ( idx integer, lng BLOB, dt date )
--- insert some BLOB data
ok 106
ok 107
ok 108
ok 109
--- fetch BLOB data back again -- truncated - LongTruncOk == 1
LongReadLen 20, LongTruncOk 1
ok 110
ok 111
ok 112
ok 113
ok 114
ok 115
--- fetch BLOB data back again -- truncated - LongTruncOk == 0
LongReadLen
