Received: from post.demon.co.uk by lion with SMTP (PP) id <29321-35@lion>;

Received: from post.demon.co.uk by lion with SMTP (PP) id <29321-35@lion>;
Thu, 6 Apr 1995 07:08:59 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 05 Apr 95 22:58:35 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa04786;
5 Apr 95 23:58 GMT-60:00
Received: by gw.home.vix.com id AA24652; Wed, 5 Apr 95 07:20:49 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA24644; Wed, 5 Apr 95 07:20:43 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa08712;
5 Apr 95 15:04 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa23859;
5 Apr 95 15:03 GMT-60:00
Received: from ig.co.uk by lion id <25811-0@lion>;
Wed, 5 Apr 1995 15:02:58 +0100
To: [email protected]
Subject: ANNOUNCE: DBD-Oracle-0.14.tar.Z
Cc: [email protected], [email protected]
Date: Wed, 5 Apr 1995 15:02:58 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

This new release of the Oracle driver adds no new functionality :-(
but does fix assorted build and core-dump problems.

Thanks to Terry Greenlaw <[email protected]> for giving
me enough information to fix these.

Apologies to all those who have spent time fighting with earlier
versions.

The new release can be found in the usual place

ftp.demon.co.uk:/pub/perl/db/DBD/Oracle/DBD-Oracle-0.14.tar.Z

Can all users *please* report failure or _success_ to me with
details of your platform and exact Oracle version.

You should be using DBI-0.54 (announced last week) with this.

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <29321-48@lion>;
Thu, 6 Apr 1995 07:10:46 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 06 Apr 95 04:47:48 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa14509;
6 Apr 95 5:47 GMT-60:00
Received: by gw.home.vix.com id AA17826; Wed, 5 Apr 95 14:06:44 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA17822; Wed, 5 Apr 95 14:06:42 -0700
Received: from centhub (centhub.mnet.uswest.com [151.116.23.137])
by uswat.advtech.uswest.com (8.6.11/8.6.10) with SMTP id PAA02955;
Wed, 5 Apr 1995 15:06:40 -0600
Original-Received: by centhub.mnet.uswest.com (M-Net
Hub.950111)
PP-warning: Illegal Received field on preceding line
Received: by coefmd3.uswest.com. (5.0/SMI-SVR4) id AA12113;
Wed, 5 Apr 1995 15:05:42 +0700
From: John Liptak <[email protected]>
Message-Id: <[email protected].>
Subject: 0.14 build failure
To: [email protected], [email protected]
Date: Wed, 5 Apr 1995 15:05:41 -0600 (MDT)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 2070

Solaris 2.3, Oracle 7, perl5.001 patched for Tk and DBI:

(PS we also have Oracle 6 and the header files listed are not in
that version as well :(

coefmd5 [/home/jliptak/satan/Oracle] 502 make realclean
rm -rf *~ t/*~ *.o *.a mon.out core so_locations Oracle.bs Oracle.bso Oracle.exp Oracle.c ./blib
mv Makefile Makefile.old 2>/dev/null
rm -rf /home/jliptak/satan/Oracle/blib/auto/DBD/Oracle /home/jliptak/satan/Oracle/blib/auto/DBD/Oracle
rm -f /home/jliptak/satan/Oracle/blib/auto/DBD/Oracle/Oracle.so /home/jliptak/satan/Oracle/blib/auto/DBD/Oracle/Oracle.bs
rm -f /home/jliptak/satan/Oracle/blib/auto/DBD/Oracle/Oracle.a /home/jliptak/satan/Oracle/blib/Oraperl.pm /home/jliptak/satan/Oracle/blib/DBD/Oracle.pm
rm -rf Makefile Makefile.old
rm -f ./perlmain.o ./perlmain.c Makefile
coefmd5 [/home/jliptak/satan/Oracle] 503 perl Makefile.PL
Using Oracle in /u3/oracle7/dbms/ora071604
Using oracle.mk version 7.69
Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio
Writing Makefile for DBD::Oracle
coefmd5 [/home/jliptak/satan/Oracle] 504 make
mkdir /home/jliptak/satan/Oracle/blib
mkdir /home/jliptak/satan/Oracle/blib/DBD
mkdir /home/jliptak/satan/Oracle/blib/auto
mkdir /home/jliptak/satan/Oracle/blib/auto/DBD
mkdir /home/jliptak/satan/Oracle/blib/auto/DBD/Oracle
/home/jliptak/bin/perl /usr/local/lib/perl5/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc Oracle.c
clcc -c -O -PIC -I/usr/local/lib/perl5/sun4-solaris/CORE -I/usr/local/lib/perl5/sun4-solaris/DBI -I/u3/oracle7/dbms/ora071604/rdbms/demo Oracle.c
"./Oracle.h", line 8: Can't find include file oratypes.h
"./Oracle.h", line 10: Can't find include file ocidfn.h
"./Oracle.h", line 13: Can't find include file ociapr.h
*** Error code 2
make: Fatal error: Command failed for target `Oracle.o'

--
John Liptak - MTS U S WEST Communications
WK (303) 965-8853 1999 Broadway Room 1510
PG (303) 820-9284 Denver, Colorado 80202
[email protected] [email protected]

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <11771-6@lion>;
Fri, 7 Apr 1995 07:04:00 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 06 Apr 95 22:05:22 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa14119;
6 Apr 95 23:05 GMT-60:00
Received: by gw.home.vix.com id AA11801; Thu, 6 Apr 95 05:33:20 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA11797; Thu, 6 Apr 95 05:33:18 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa14577;
6 Apr 95 13:32 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa19661;
6 Apr 95 13:32 GMT-60:00
Received: from ig.co.uk by lion id <02672-0@lion>;
Thu, 6 Apr 1995 13:28:28 +0100
To: [email protected], [email protected]
Subject: Re: 0.14 build failure
Date: Thu, 6 Apr 1995 13:28:28 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: John Liptak <[email protected]>
>
>
> Solaris 2.3, Oracle 7, perl5.001 patched for Tk and DBI:
>
> (PS we also have Oracle 6 and the header files listed are not in
> that version as well :(
>
> perl Makefile.PL
> Using Oracle in /u3/oracle7/dbms/ora071604
> Using oracle.mk version 7.69
> Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio
> Writing Makefile for DBD::Oracle

> /home/jliptak/bin/perl /usr/local/lib/perl5/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc Oracle.c
> clcc -c -O -PIC -I/usr/local/lib/perl5/sun4-solaris/CORE -I/usr/local/lib/perl5/sun4-solaris/DBI -I/u3/oracle7/dbms/ora071604/rdbms/demo Oracle.c
> "./Oracle.h", line 8: Can't find include file oratypes.h
> "./Oracle.h", line 10: Can't find include file ocidfn.h
> "./Oracle.h", line 13: Can't find include file ociapr.h
> *** Error code 2
> make: Fatal error: Command failed for target `Oracle.o'
>
Have you installed Pro*C?

Try:
find /u3/oracle7/dbms/ora071604 -name oratypes.h -print

what do you get, if anything? If not then Pro*C (with OCI) has not
been installed properly/fully.

It's worth pointing out that the -I/u3/oracle7/dbms/ora071604/rdbms/demo
in the compile command line comes from the oracle oracle.mk file and
not from Makefile.PL. In other words, that's where _oracle_ thinks the
files should be!

In fact the oracle.mk file says:
# directory that contain oratypes.h and other oci demo program header files
INCLUDE= -I$(ORACLE_HOME)/rdbms/demo

> John Liptak - MTS U S WEST Communications
> [email protected] [email protected]
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <24301-2@lion>;
Wed, 12 Apr 1995 07:01:09 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 12 Apr 95 02:07:22 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa24277;
12 Apr 95 3:07 GMT-60:00
Received: by gw.home.vix.com id AA08926; Tue, 11 Apr 95 12:43:26 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA08920; Tue, 11 Apr 95 12:43:22 -0700
Received: from localhost by colossus.cse.psu.edu with SMTP id <46408>;
Tue, 11 Apr 1995 15:43:11 -0400
X-Mailer: exmh version 1.6gamma+ 4/3/95
To: [email protected], [email protected]
Subject: Oraywww
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Tue, 11 Apr 1995 15:40:00 -0400
From: John D Groenveld <[email protected]>
Message-Id: <[email protected]>

Anyone have any luck using Arthur Yasinski's oraywww package with Tim Bunce's
DBPerl? I know that DBPerl is still in pre-release, but what better way to
test it out.
Thanks
John
[email protected]

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <13194-0@lion>;
Thu, 13 Apr 1995 23:20:25 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 13 Apr 95 22:18:21 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa04986;
13 Apr 95 23:17 GMT-60:00
Received: by gw.home.vix.com id AA18912; Thu, 13 Apr 95 09:18:55 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA18908; Thu, 13 Apr 95 09:18:51 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa11965;
13 Apr 95 17:18 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa23963;
13 Apr 95 17:18 GMT-60:00
Received: from ig.co.uk by lion id <07167-0@lion>;
Thu, 13 Apr 1995 17:17:45 +0100
To: [email protected]
Subject: Re: dbperl and oraywww
Cc: [email protected]
Date: Thu, 13 Apr 1995 17:17:45 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: Arthur Yasinski <[email protected]>
>
> Hi Tim,
>
> I have "talked" with you on a couple of occasions via usenet and
> the Oracle/Perl newsgroups.
>
> A couple of people over the last few weeks have sent me email asking
> if I was planning on porting oraywww to something more generic,
> possibly taking advantage of your dbperl.
>
Sounds like a good idea.

> I would like to take a look at it, but since I kinda dropped off
> the thread, I am not sure of the current status of dbperl. I checked
> your ftp site, demon, and cruised through the DBI directory.
>
Join the perldb-interest mailing list (email to
[email protected]) to stay up-to-date.

> Can you offer any input to this? I would very much welcome your
> suggestions.
>
Glad to help if I can.

The current status is that I have a basic oracle interface implemented
and I've implemented an oraperl emulation layer above that. ftp.demon
has the latest releases of the DBI and DBD::Oracle modules.

My strategy at the moment is to concentrate on developing basic drivers
with emulators for the old-style interfaces. The key point is to get
something useful working quickly while avoiding the need to agree on
the generic interface. That can come later.

> Thanks (and Happy Easter),
> Arthur
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <16381-0@lion>;
Fri, 14 Apr 1995 05:20:20 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Fri, 14 Apr 95 02:00:35 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa21035;
14 Apr 95 3:00 GMT-60:00
Received: by gw.home.vix.com id AA14694; Thu, 13 Apr 95 16:05:48 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA14690; Thu, 13 Apr 95 16:05:46 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa11475;
14 Apr 95 0:05 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id ab17030;
14 Apr 95 0:05 GMT-60:00
Received: from ig.co.uk by lion id <13368-0@lion>;
Fri, 14 Apr 1995 00:00:42 +0100
To: [email protected]
Subject: DBD-Oracle-0.14 on Solaris 2
Date: Fri, 14 Apr 1995 00:00:42 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

Has anyone other than David Moellenhoff built DBD-Oracle-0.14 on Solaris 2?

Dave's having some problems (SIGILL, Illegal instruction core dump in
XS_DynaLoader_dl_load_file) and I'm starting to run short of ideas.

His config:

Summary of my perl5 (patchlevel 1) configuration:
Platform:
osname=solaris, osver=2.3, archname=sun4-solaris
uname='sunos pebble 5.3 generic_101318-59 sun4m sparc '
hint=previous
Compiler:
cc='gcc', optimize='-O2'
cppflags=''
ccflags =''
ldflags =''
stdchar='unsigned char', d_stdstdio=define, usevfork=false
voidflags=15, castflags=0, d_casti32=define, d_castneg=define
intsize=4, alignbytes=8, usemymalloc=y, randbits=15
Libraries:
so=so
libpth=/lib /usr/lib /usr/ccs/lib /usr/local/lib
libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
libc=/usr/lib/libc.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef
cccdlflags='-fpic', ccdlflags='', lddlflags='-G'

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <04878-4@lion>;
Tue, 18 Apr 1995 23:15:30 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 18 Apr 95 21:16:20 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa19099;
18 Apr 95 22:15 GMT-60:00
Received: by gw.home.vix.com id AA08606; Tue, 18 Apr 95 06:38:56 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA08602; Tue, 18 Apr 95 06:38:54 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa10060;
18 Apr 95 14:37 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa03378;
18 Apr 95 14:37 GMT-60:00
Received: from ig.co.uk by lion id <14604-0@lion>;
Tue, 18 Apr 1995 14:37:42 +0100
To: [email protected]
Subject: Re: DBD-Oracle-0.14 on Solaris 2
Cc: [email protected]
Date: Tue, 18 Apr 1995 14:37:42 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: James Taylor <[email protected]>
>
> >>> Tim Bunce writes:
> TB> Has anyone other than David Moellenhoff built DBD-Oracle-0.14 on
> TB> Solaris 2? Dave's having some problems (SIGILL, Illegal
> TB> instruction core dump in XS_DynaLoader_dl_load_file) and I'm
> TB> starting to run short of ideas.
>
> TB> His config:
>
> TB> Summary of my perl5 (patchlevel 1) configuration: Platform:
> TB> osname=solaris, osver=2.3, archname=sun4-solaris uname='sunos
> TB> pebble 5.3 generic_101318-59 sun4m sparc ' hint=previous
> TB> Compiler: cc='gcc', optimize='-O2' cppflags='' ccflags =''
> TB> ldflags ='' stdchar='unsigned char', d_stdstdio=define,
> TB> usevfork=false voidflags=15, castflags=0, d_casti32=define,
> TB> d_castneg=define intsize=4, alignbytes=8, usemymalloc=y,
> TB> randbits=15 Libraries: so=so libpth=/lib /usr/lib /usr/ccs/lib
> TB> /usr/local/lib libs=-lsocket -lnsl -ldl -lm -lc -lcrypt
> TB> libc=/usr/lib/libc.so Dynamic Linking: dlsrc=dl_dlopen.xs,
> TB> dlext=so, d_dlsymun=undef cccdlflags='-fpic', ccdlflags='',
> TB> lddlflags='-G'
>
> TB> Regards, Tim.
>
> I compiled DBD-Oracle-0.14 on Solaris 2.4. Received the following
> error when executing the test:
>
> /afs/srtc.srs.gov/project/enterprise/net/ftp.demon.co.uk/DBD/Oracle > make test
> /usr/bin/perl -I./blib -I./blib -I/usr/local/lib/perl5/sun4-solaris -I/usr/local/lib/perl5 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> t/base..............ok
> t/main..............ok
> All tests successful.
> Files=2, Tests=6, 7 secs ( 1.36 cusr 0.71 csys = 2.07 cpu)
> /usr/bin/perl -I./blib -I./blib -I/usr/local/lib/perl5/sun4-solaris -I/usr/local/lib/perl5 test.pl
> Oraperl test application $Revision: 1.4 $
> DBD::Oracle driver installed as DBI::dr=HASH(0x142b8c)
> DBI::dr=HASH(0x154cb0) debug level set to 1
>
> Oraperl Emulation Interface $Revision: 1.7 $
> Oracle Driver $Revision: 1.9 $
> DBI Switch by Tim Bunce, $Revision: 1.33 $
>
> lda=DBI::db=HASH(0x154d88)
> fbh 1: 'NUM_T' NULLable, type 2, dbsize 3, dsize 40, p0 s0
> out: ftype 5, indp 0, bufl 40, rlen 0, rcode 0
> fbh 2: 'DATE_T' NULLable, type 12, dbsize 7, dsize 75, p0 s0
> out: ftype 5, indp 0, bufl 75, rlen 0, rcode 0
> fbh 3: 'CHAR_T' NULLable, type 1, dbsize 30, dsize 30, p0 s0
> out: ftype 5, indp 0, bufl 30, rlen 0, rcode 0
> Names: 'NUM_T', 'DATE_T', 'CHAR_T'
> Lengths: '40', '75', '30'
> Types: '2', '12', '1'
> Fields: 3
> Data rows:
> fetch: 79.2 17-APR-95 SYSTEM
> last rows:
> csr out of scope...
> ora_logoff
> lda out of scope...
> *** Signal 10 - core dumped
> make: Fatal error: Command failed for target `test'
>
>
> Is this the same error?
>
I don't know.

Did you get any compiler warnings?

What version of oracle are you using?

Please send stack trace from the core.

> James
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <04878-6@lion>;
Tue, 18 Apr 1995 23:15:48 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 18 Apr 95 21:48:10 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa27148;
18 Apr 95 22:47 GMT-60:00
Received: by gw.home.vix.com id AA08573; Tue, 18 Apr 95 06:36:24 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA08569; Tue, 18 Apr 95 06:36:23 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa09862;
18 Apr 95 14:34 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa02446;
18 Apr 95 14:34 GMT-60:00
Received: from ig.co.uk by lion id <14476-0@lion>;
Tue, 18 Apr 1995 14:34:25 +0100
To: [email protected]
Subject: Use of perldb-interest
Date: Tue, 18 Apr 1995 14:34:25 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

Please don't just send messages to me - share them - post them to the
mailing list so that others can be kept up to date and/or contribute.

Still, I'm glad things are picking up :-)

Thanks to all those who are giving it a go.

Regards,
Tim.

---+++---
Received: from punt.demon.co.uk by lion with SMTP (PP) id <05938-0@lion>;
Wed, 19 Apr 1995 00:31:45 +0100
Received: from punt.demon.co.uk via puntmail for [email protected];
Tue, 18 Apr 95 23:28:22 GMT
Received: from gw.home.vix.com by punt.demon.co.uk id aa19946;
19 Apr 95 0:27 GMT-60:00
Received: by gw.home.vix.com id AA08120; Tue, 18 Apr 95 06:29:44 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA08116; Tue, 18 Apr 95 06:29:40 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa09346;
18 Apr 95 14:27 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa00659;
18 Apr 95 14:27 GMT-60:00
Received: from ig.co.uk by lion id <14206-0@lion>;
Tue, 18 Apr 1995 14:27:27 +0100
To: [email protected]
Subject: Re: DBD-Oracle-0.14 on Solaris 2
Cc: [email protected]
Date: Tue, 18 Apr 1995 14:27:27 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: John Liptak <[email protected]>
>
> >
> > Has anyone other than David Moellenhoff built DBD-Oracle-0.14 on Solaris 2?
> >
>
> I have. I'm using CenterLine for a compiler and I'm 11 kernal
> patches ahead.
>
> SunOS coefmd3 5.3 Generic_101318-70 sun4d sparc
>
> [...]
> --
> John Liptak - MTS U S WEST Communications
> WK (303) 965-8853 1999 Broadway Room 1510
> PG (303) 820-9284 Denver, Colorado 80202
> [email protected] [email protected]
>
>
Thanks.

Did you have to make any changes or did it build out-of-the-box ?

Which version of Oracle are you using (please also give the oracle.mk
version number that Makefile.PL gave you).

Regards,
Tim.

---+++---
Received: from punt.demon.co.uk by lion with SMTP (PP) id <05936-1@lion>;
Wed, 19 Apr 1995 00:31:50 +0100
Received: from punt.demon.co.uk via puntmail for [email protected];
Tue, 18 Apr 95 23:30:02 GMT
Received: from gw.home.vix.com by punt.demon.co.uk id aa20284;
19 Apr 95 0:28 GMT-60:00
Received: by gw.home.vix.com id AA13674; Tue, 18 Apr 95 08:16:58 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA13668; Tue, 18 Apr 95 08:16:52 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id ab15095;
18 Apr 95 15:57 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa25812;
18 Apr 95 15:56 GMT-60:00
Received: from ig.co.uk by lion id <15493-0@lion>;
Tue, 18 Apr 1995 15:03:35 +0100
To: [email protected]
Subject: Re: DBD-Oracle-0.14 on Solaris 2
Cc: [email protected]
Date: Tue, 18 Apr 1995 15:03:35 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: [email protected]
>
>
> Hi, Tim=
>
> At last, a chance to contribute! I'd never felt able to do anything
> but lurk, but I finally got DBI+DBD to build and pass tests.
>
Great.

> > Date: Fri, 14 Apr 1995 00:00:42 +0100
> > From: Tim Bunce <[email protected]>
> >
> > Has anyone other than David Moellenhoff built DBD-Oracle-0.14 on Solaris 2?
> >
> > Dave's having some problems (SIGILL, Illegal instruction core dump in
> > XS_DynaLoader_dl_load_file) and I'm starting to run short of ideas.
> >
> ...
>
> Using Sun's C compiler, I built and passed tests for DBI_0.54 and
> DBD_Oracle_0.14.tar.Z.
>
> First, here's my config (perl 5.001c + pp_hot.patch). Sorry that the
> non-standard installation clouds the issue a little.
> ========================================================================
> |fox@jade 29 % perl -e 'use Config; print Config::myconfig()';
> |Summary of my perl5 (patchlevel 1) configuration:
> | Platform:
> | osname=solaris, osver=2.3, archname=sun4-solaris
> | uname='sunos jade 5.3 generic_101318-41 sun4m sparc '
> | hint=previous
> | Compiler:
> | cc='cc', optimize='-O'
> | cppflags='-I/scratch/local/include -L/scratch/local/lib -R /scratch/local/lib'
> | ccflags ='-I/scratch/local/include -L/scratch/local/lib -R /scratch/local/lib'
> | ldflags ='-L/scratch/local/lib -R /scratch/local/lib'
> | stdchar='unsigned char', d_stdstdio=define, usevfork=false
> | voidflags=15, castflags=0, d_casti32=define, d_castneg=define
> | intsize=4, alignbytes=8, usemymalloc=y, randbits=15
> | Libraries:
> | so=so
> | libpth=/scratch/local/lib /lib /usr/lib /usr/ccs/lib /usr/local/lib
> | libs=-lsocket -lnsl -lgdbm -ldl -lm -lc -lcrypt
> | libc=/usr/lib/libc.so
> | Dynamic Linking:
> | dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=
> | cccdlflags='-K pic', ccdlflags='', lddlflags='-G -R /scratch/local/lib -L/scratch/local/lib'
> ========================================================================
>
> I had to patch Makefile.PL for DBD (add -I$Config{'privlib'} to
> $opts{'INC'}) so that DBIXS.h is found.

That shouldn't be needed. The DBI Makefile.PL installs DBIXS.h into:

$(INST_ARCHLIBDIR)/DBI/DBIXS.h

and DBD::Oracle Makefile.PL says:

$opts{'INC'} = "$OCIMK{'INCLUDE'} -I$Config{'archlib'}/DBI";

It would appear that DBIXS.h got installed in the wrong place.
Can you look into that for me?

> The test didn't seem to take
> ORACLE_USERID and TWO_TASK, so I hard coded valid arguments to ora_login:
>
> ========================================================================
> |local($lda) = &ora_login('t:foo:bar, 'fox3/fox3', '')
> | || die "ora_login: $ora_errno: $ora_errstr\n";
> |
> ========================================================================
>
Currently connect (called via ora_login) does this:

sub connect {
my($drh, $dbname, $user, $auth)= @_;

if ($dbname){ # else keep current env settings
if ($dbname !~ /:/){
@ENV{qw(ORACLE_SID TWO_TASK)} = ($dbname, '');
} else {
@ENV{qw(ORACLE_SID TWO_TASK)} = ('', $dbname);
}
}
...
my $imp_dbh = orlon($drh, $user, $auth); # OCI routine

I'm not convinced this is correct and/or optimal.

I'd appreciate any suggestions.

> Here's the output from make and test for DBD:
>
> ========================================================================
> |fox@jade 31 % pwd
> |/scratch/gnu/DBD/Oracle
> |fox@jade 32 % make realclean
> |rm -rf *~ t/*~ *.o *.a mon.out core so_locations Oracle.bs Oracle.bso Oracle.exp Oracle.c ./blib
> |mv Makefile Makefile.old 2>/dev/null
> |rm -rf ./blib/auto/DBD/Oracle ./blib/auto/DBD/Oracle
> |rm -f ./blib/auto/DBD/Oracle/Oracle.so ./blib/auto/DBD/Oracle/Oracle.bs
> |rm -f ./blib/auto/DBD/Oracle/Oracle.a ./blib/Oraperl.pm ./blib/DBD/Oracle.pm
> |rm -rf Makefile Makefile.old
> |rm -f ./perlmain.o ./perlmain.c Makefile

> |fox@jade 33 % perl Makefile.PL
> |Using Oracle in /gf/env/solaris2/oracle-7.0.16
> |Using oracle.mk version 7.69
> |Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio

Please note, anyone sending problem reports should include at least the info above.
Thanks.

> |Writing Makefile for DBD::Oracle
> |fox@jade 34 % make
> |mkdir ./blib
> |mkdir ./blib/DBD
> |mkdir ./blib/auto
> |mkdir ./blib/auto/DBD
> |mkdir ./blib/auto/DBD/Oracle
> |/scratch/local/bin/perl /scratch/local/lib/perl5/ExtUtils/xsubpp -typemap /scratch/local/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc Oracle.c
> |cc -c -I/scratch/local/include -L/scratch/local/lib -R /scratch/local/lib -O -K pic -I/scratch/local/lib/perl5/sun4-solaris/CORE -I/scratch/local/lib/perl5/sun4-solaris/DBI -I/scratch/local/lib/perl5/DBI -I/gf/env/solaris2/oracle-7.0.16/rdbms/demo Oracle.c
> |"Oracle.c", line 73: warning: argument #2 is incompatible with prototype:
> | prototype: pointer to char : "/scratch/local/lib/perl5/sun4-solaris/CORE/proto.h", line 441
> | argument : pointer to uchar
> |"Oracle.c", line 161: warning: assignment type mismatch:
> | pointer to schar "=" pointer to char
> |"Oracle.c", line 480: warning: argument #1 is incompatible with prototype:
> | prototype: pointer to char : "/scratch/local/lib/perl5/sun4-solaris/CORE/proto.h", line 274
> | argument : pointer to schar

I think I've fixed these for the next release. They were not dangerous.

> |Running mkbootstrap for DBD::Oracle ()
> |ld -o blib/auto/DBD/Oracle/Oracle.so -G -R /scratch/local/lib -L/scratch/local/lib Oracle.o -L/gf/env/solaris2/oracle-7.0.16/lib /gf/env/solaris2/oracle-7.0.16/lib/crti.o /gf/env/solaris2/oracle-7.0.16/lib/crt1.o /gf/env/solaris2/oracle-7.0.16/lib/__fstd.o /gf/env/solaris2/oracle-7.0.16/lib/libocic.a /gf/env/solaris2/oracle-7.0.16/lib/osntab.o -lsqlnet -lora -lsqlnet -lnlsrtl -lcv6 -lcore -lnlsrtl -lcv6 -lcore `cat /gf/env/solaris2/oracle-7.0.16/rdbms/lib/sysliblist` -Y P,:/usr/ccs/lib:/usr/lib -Qy -lc /gf/env/solaris2/oracle-7.0.16/lib/crtn.o -lcore -lsocket -lnsl -lm -ldl -laio
> |cp Oracle.bs ./blib/auto/DBD/Oracle/Oracle.bs
> |cp Oraperl.pm blib/Oraperl.pm
> |cp Oracle.pm blib/DBD/Oracle.pm
> |fox@jade 35 % make test
> |/scratch/local/bin/perl -I./blib -I./blib -I/scratch/local/lib/perl5/sun4-solaris -I/scratch/local/lib/perl5 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> |t/base..............ok
> |t/main..............ok
> |All tests successful.
> |Files=2, Tests=6, 2 secs ( 1.45 cusr 0.66 csys = 2.11 cpu)
> |/scratch/local/bin/perl -I./blib -I./blib -I/scratch/local/lib/perl5/sun4-solaris -I/scratch/local/lib/perl5 test.pl
> |Oraperl test application $Revision: 1.4 $
> |DBD::Oracle driver installed as DBI::dr=HASH(0x14bd88)
> | DBI::dr=HASH(0x153a9c) debug level set to 1
> |
> |Oraperl Emulation Interface $Revision: 1.7 $
> |Oracle Driver $Revision: 1.9 $
> |DBI Switch by Tim Bunce, $Revision: 1.33 $
> |
> |lda=DBI::db=HASH(0x153b74)
> |fbh 1: 'NUM_T' NULLable, type 2, dbsize 3, dsize 40, p0 s0
> | out: ftype 5, indp 0, bufl 40, rlen 0, rcode 0
> |fbh 2: 'DATE_T' NULLable, type 12, dbsize 7, dsize 75, p0 s0
> | out: ftype 5, indp 0, bufl 75, rlen 0, rcode 0
> |fbh 3: 'CHAR_T' NULLable, type 1, dbsize 30, dsize 30, p0 s0
> | out: ftype 5, indp 0, bufl 30, rlen 0, rcode 0
> |Names: 'NUM_T', 'DATE_T', 'CHAR_T'
> |Lengths: '40', '75', '30'
> |Types: '2', '12', '1'
> |Fields: 3
> |Data rows:
> |fetch: 79.2 17-APR-95 FOXB3
> |last rows:
> |csr out of scope...
> |ora_logoff
> |lda out of scope...
> |fox@jade 36 %
> ========================================================================
>
> I'm sorry that my success doesn't shed much light on the problem with
> gcc and SIGILL. Has David built and run the demo Pro*C programs from
> $ORACLE_HOME/proc/demo? If this has already been done, I could, if
> you think it worthwhile, rebuild with gcc and see what happens
> compared to Sun cc. (We have gcc version cygnus-2.0.2.)
>
> I've always wanted to write and say thanks for your work on an
> interface to Oracle, but didn't want to clog your mailbox with a
> mere 'attaboy'. Now that I have another reason to write, thanks for
> your efforts on DBD--your work is greatly appreciated!
>
You'd be surprised how much I'd appreciate "a mere 'attaboy'".

Thanks.

> =Jim Fox
> Schlumberger Austin Systems Center
> Austin, Texas
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <07692-4@lion>;
Wed, 19 Apr 1995 07:02:11 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 19 Apr 95 01:06:20 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa16479;
19 Apr 95 2:05 GMT-60:00
Received: by gw.home.vix.com id AA26079; Tue, 18 Apr 95 11:42:14 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA26075; Tue, 18 Apr 95 11:42:13 -0700
Received: from localhost by colossus.cse.psu.edu with SMTP id <46184>;
Tue, 18 Apr 1995 14:42:07 -0400
X-Mailer: exmh version 1.6delta 4/7/95
To: [email protected]
Subject: DBPerl/Oraperl
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Tue, 18 Apr 1995 14:41:32 -0400
From: John D Groenveld <[email protected]>
Message-Id: <[email protected]>

When using dbperl scripts, should we be using the oraperl emulation stuff or
should we be using the interface as described in the dbispec file?
John
[email protected]

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <07693-3@lion>;
Wed, 19 Apr 1995 07:02:15 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 19 Apr 95 01:16:10 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa18420;
19 Apr 95 2:15 GMT-60:00
Received: by gw.home.vix.com id AA10553; Tue, 18 Apr 95 15:37:51 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA10548; Tue, 18 Apr 95 15:37:50 -0700
Received: from hpsid.sid.hp.com by hp.com with SMTP (1.37.109.15/15.5+ECS 3.3)
id AA071194663; Tue, 18 Apr 1995 15:37:43 -0700
Received: from teton.sid.hp.com by hpsid.sid.hp.com
with SMTP (16.6/15.5+IOS 3.21+OM) id AA21297;
Tue, 18 Apr 95 15:37:41 -0700
Received: by teton.sid.hp.com (1.37.109.8/15.5+IOS 3.22) id AA02628;
Tue, 18 Apr 1995 15:26:33 -0700
From: Brian Zhou <[email protected]>
Message-Id: <[email protected]>
Subject: I want to join.
To: [email protected]
Date: Tue, 18 Apr 95 15:26:32 PDT
Mailer: Elm [revision: 70.85]

I would like a subscription to the DBperl mailing list. My address is

Brian Zhou [email protected]

Thank you.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <07692-6@lion>;
Wed, 19 Apr 1995 07:02:26 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 19 Apr 95 01:24:29 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa19988;
19 Apr 95 2:23 GMT-60:00
Received: by gw.home.vix.com id AA16379; Tue, 18 Apr 95 09:08:18 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA16375; Tue, 18 Apr 95 09:08:17 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa18767;
18 Apr 95 16:45 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa10354;
18 Apr 95 16:45 GMT-60:00
Received: from ig.co.uk by lion id <17776-0@lion>;
Tue, 18 Apr 1995 16:45:05 +0100
To: [email protected]
Subject: Re: DBD-Oracle-0.14 on Solaris 2
Cc: [email protected]
Date: Tue, 18 Apr 1995 16:45:05 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: John Liptak <[email protected]>
>
> >
> > > SunOS coefmd3 5.3 Generic_101318-70 sun4d sparc
> >
> > Did you have to make any changes or did it build out-of-the-box ?
>
> After some problems with header files and compiler flags,
> out-of-the-box.
>
PLEASE PLEASE give DETAILS so I can FIX it for next time!

I'm trying to make it install out-of-the-box so I won't have to answer
hundreds of 'I can't get it to compile with Oracle 7.x.y.z ...' messages

:-)

> > Which version of Oracle are you using (please also give the oracle.mk
> > version number that Makefile.PL gave you).
>
> ORACLE7 Server Release 7.0.16.4.0 - Production
>
>
> # $Header: oracle.mk.pp 7.69 93/10/27 23:20:52 sylee Osd<unix> $ oracle.mk.pp Copyr (c) 1986 Oracle
>
Thanks. That's useful, especially once you tell me what you needed to change!

:-)

> --
> John Liptak - MTS U S WEST Communications
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <07692-9@lion>;
Wed, 19 Apr 1995 07:02:44 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 19 Apr 95 02:30:45 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa03135;
19 Apr 95 3:30 GMT-60:00
Received: by gw.home.vix.com id AA25689; Tue, 18 Apr 95 11:39:47 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA25684; Tue, 18 Apr 95 11:39:42 -0700
Received: by srs.gov id AA26125 (InterLock SMTP Gateway 1.1
for [email protected]); Tue, 18 Apr 1995 14:38:35 -0400
Received: by srs.gov (Internal Mail Agent-2); Tue, 18 Apr 1995 14:38:35 -0400
Received: by srs.gov (Internal Mail Agent-1); Tue, 18 Apr 1995 14:38:35 -0400
Date: Tue, 18 Apr 1995 14:36:11 -0400
From: James Taylor <[email protected]>
Subject: Re: DBD-Oracle-0.14 on Solaris 2
In-Reply-To: <[email protected]>
To: Tim Bunce <[email protected]>
Cc: [email protected], [email protected]
Reply-To: James Taylor <[email protected]>
Message-Id: <[email protected]>
X-Envelope-To: perldb-interest%[email protected],
Tim.Bunce%[email protected]
Content-Transfer-Encoding: 7BIT
X-Attribution: james.taylor
References: <[email protected]>

>>> Tim Bunce writes:
>> From: James Taylor <[email protected]>
>>
>> >>> Tim Bunce writes:
TB> Has anyone other than David Moellenhoff built DBD-Oracle-0.14 on
TB> Solaris 2? Dave's having some problems (SIGILL, Illegal
TB> instruction core dump in XS_DynaLoader_dl_load_file) and I'm
TB> starting to run short of ideas.
>>
TB> Regards, Tim.
>> I compiled DBD-Oracle-0.14 on Solaris 2.4. Received the
>> following error when executing the test:
>>
>> /afs/srtc.srs.gov/project/enterprise/net/ftp.demon.co.uk/DBD/Oracle
>> > make test /usr/bin/perl -I./blib -I./blib
>> -I/usr/local/lib/perl5/sun4-solaris -I/usr/local/lib/perl5 -e
>> 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests
>> @ARGV;' t/*.t t/base..............ok t/main..............ok All
>> tests successful. Files=2, Tests=6, 7 secs ( 1.36 cusr 0.71 csys
>> = 2.07 cpu) /usr/bin/perl -I./blib -I./blib
>> -I/usr/local/lib/perl5/sun4-solaris -I/usr/local/lib/perl5
>> test.pl Oraperl test application $Revision: 1.4 $ DBD::Oracle
>> driver installed as DBI::dr=HASH(0x142b8c) DBI::dr=HASH(0x154cb0)
>> debug level set to 1

Well, I compiled again and DBD-Oracle-0.14 passed all tests ok.

Oracle: 7.1.4
Perl : 5.001 patches a-d
OS: Solaris 2.4
CC: SPARCompiler C Version 2.01

Modifications:

I had to change the Makefile LD flag from LD = cc to LD = ld. This
prevented the following errors:

ld: fatal: symbol `_fini' is multiply defined:
(file /opt/SUNWspro/bin/../SC2.0.1/crti.o and file
/home/oracle/product/7.1.4/lib/crti.o);
ld: fatal: symbol `_init' is multiply defined:
(file /opt/SUNWspro/bin/../SC2.0.1/crti.o and file
/home/oracle/product/7.1.4/lib/crti.o);

I seems that when cc calls ld it adds

/usr/ccs/bin/ld -dy /opt/SUNWspro/bin/../SC2.0.1/crti.o /opt/SUNWspro/bin/../SC2.0.1/values-xt.o

which causes the multiply defined symbol. Using ld directly solves
the problem. Is there a better/preferred way of doing this?

My previous core dump was caused by my commenting the following line
in Makefile:

COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/__fstd.o

I did this to prevent the same errors as above, but I guess I really
DID need the Oracle version of _fini (which was where my original
version dumped core).

James

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <11058-1@lion>;
Wed, 19 Apr 1995 17:21:49 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 19 Apr 95 11:54:15 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa15100;
19 Apr 95 12:53 GMT-60:00
Received: by gw.home.vix.com id AA06748; Tue, 18 Apr 95 23:01:18 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA06740; Tue, 18 Apr 95 23:01:16 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa11840;
19 Apr 95 7:01 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa15088;
19 Apr 95 7:00 GMT-60:00
Received: from ig.co.uk by lion id <06755-0@lion>;
Wed, 19 Apr 1995 01:31:16 +0100
To: [email protected]
Subject: Re: DBD-Oracle-0.14 on Solaris 2
Cc: [email protected]
Date: Wed, 19 Apr 1995 01:31:16 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: James Taylor <[email protected]>
>
> Well, I compiled again and DBD-Oracle-0.14 passed all tests ok.
>
Thanks for getting to the bottom of this.

> Oracle: 7.1.4
> Perl : 5.001 patches a-d
> OS: Solaris 2.4
> CC: SPARCompiler C Version 2.01
>
> Modifications:
>
> I had to change the Makefile LD flag from LD = cc to LD = ld. This
> prevented the following errors:
>
> ld: fatal: symbol `_fini' is multiply defined:
> (file /opt/SUNWspro/bin/../SC2.0.1/crti.o and file
> /home/oracle/product/7.1.4/lib/crti.o);
> ld: fatal: symbol `_init' is multiply defined:
> (file /opt/SUNWspro/bin/../SC2.0.1/crti.o and file
> /home/oracle/product/7.1.4/lib/crti.o);
>
> I seems that when cc calls ld it adds
>
> /usr/ccs/bin/ld -dy /opt/SUNWspro/bin/../SC2.0.1/crti.o /opt/SUNWspro/bin/../SC2.0.1/values-xt.o
>
> which causes the multiply defined symbol. Using ld directly solves
> the problem. Is there a better/preferred way of doing this?
>
> My previous core dump was caused by my commenting the following line
> in Makefile:
>
> COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/__fstd.o
>
> I did this to prevent the same errors as above, but I guess I really
> DID need the Oracle version of _fini (which was where my original
> version dumped core).
>
Umm, this is tricky. I'd be more comfortable with the crt*.o supplied with
the compiler.

Can you talk to Oracle about this? Ask them...
- how their supplied crt* files differ from the files supplied with the SPARCompiler
- if they support oci programs linked with the SPARCompiler crt*.o files.
- anything else you can think of :-)

Thanks.

> James
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <13451-41@lion>;
Thu, 20 Apr 1995 07:06:33 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 19 Apr 95 20:51:21 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa05782;
19 Apr 95 21:51 GMT-60:00
Received: by gw.home.vix.com id AA27089; Wed, 19 Apr 95 04:09:14 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA27085; Wed, 19 Apr 95 04:09:12 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa03086;
19 Apr 95 12:06 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id ae02451;
19 Apr 95 12:06 GMT-60:00
Received: from ig.co.uk by lion id <09240-0@lion>;
Wed, 19 Apr 1995 11:25:23 +0100
To: [email protected], [email protected]
Subject: Re: DBPerl/Oraperl
Date: Wed, 19 Apr 1995 11:25:23 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: John D Groenveld <[email protected]>
>
> When using dbperl scripts, should we be using the oraperl emulation stuff or
> should we be using the interface as described in the dbispec file?

The oraperl emulation is the only stable interface at the moment.

If you use anything else be prepared to have to change you code
if/when the DBI interface changes.

> John
> [email protected]
>
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <13453-61@lion>;
Thu, 20 Apr 1995 07:09:53 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 20 Apr 95 03:35:54 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa28746;
20 Apr 95 4:35 GMT-60:00
Received: by gw.home.vix.com id AA11677; Wed, 19 Apr 95 16:14:43 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA11673; Wed, 19 Apr 95 16:14:42 -0700
Received: from hpsid.sid.hp.com by hp.com with SMTP (1.37.109.15/15.5+ECS 3.3)
id AA257113281; Wed, 19 Apr 1995 16:14:41 -0700
Received: from teton.sid.hp.com by hpsid.sid.hp.com
with SMTP (16.6/15.5+IOS 3.21+OM) id AA04622;
Wed, 19 Apr 95 16:14:35 -0700
Received: by teton.sid.hp.com (1.37.109.8/15.5+IOS 3.22) id AA05478;
Wed, 19 Apr 1995 16:03:27 -0700
From: Brian Zhou <[email protected]>
Message-Id: <[email protected]>
Subject: DBD Oracle on HP-UX9 9000/800, please help
To: [email protected], [email protected]
Date: Wed, 19 Apr 95 16:03:26 PDT
Mailer: Elm [revision: 70.85]

Anyone please help me, I really appreciate it. Thanks in advance.

perl5.001 and DBI-0.54 building, testing, installation fine,
but DBD-Oracle-0.14 building failed.

I am using HP-UX9.04 9000/827, Oracle v7.16.

Following is the make log:

make realclean
==============
rm -rf *~ t/*~ *.o *.a mon.out core so_locations Oracle.bs Oracle.bso Oracle.exp Oracle.c ./blib
mv Makefile Makefile.old 2>/dev/null
rm -rf ./blib/auto/DBD/Oracle ./blib/auto/DBD/Oracle
rm -f ./blib/auto/DBD/Oracle/Oracle.sl ./blib/auto/DBD/Oracle/Oracle.bs
rm -f ./blib/auto/DBD/Oracle/Oracle.a ./blib/Oraperl.pm ./blib/DBD/Oracle.pm
rm -rf Makefile Makefile.old
rm -f ./perlmain.o ./perlmain.c Makefile

perl Makefile.PL
================
Using Oracle in /oracle/oracle7.16
Using oracle.mk version 7.69
Oracle sysliblist: -lcl -lm
Writing Makefile for DBD::Oracle

make
====
mkdir ./blib
mkdir ./blib/DBD
mkdir ./blib/auto
mkdir ./blib/auto/DBD
mkdir ./blib/auto/DBD/Oracle
/usr/bin/perl /usr/local/perl5/lib/perl5/ExtUtils/xsubpp -typemap /usr/local/perl5/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc Oracle.c
cc -c -D_POSIX_SOURCE -D_HPUX_SOURCE -Aa +O1 +z -I/usr/local/perl5/lib/perl5/hpux/CORE -I/usr/local/perl5/lib/perl5/hpux/DBI -I/oracle/oracle7.16/rdbms/demo Oracle.c
cc: "Oracle.c", line 73: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.c", line 73: warning 563: Argument #2 is not the correct type.
cc: "Oracle.c", line 161: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.c", line 480: warning 604: Pointers are not assignment-compatible.
cc: "Oracle.c", line 480: warning 563: Argument #1 is not the correct type.
Running mkbootstrap for DBD::Oracle ()
ld -o ./blib/auto/DBD/Oracle/Oracle.sl -b Oracle.o -L/oracle/oracle7.16/lib /oracle/oracle7.16/lib/libocic.a /oracle/oracle7.16/lib/osntab.o -lsqlnet -lora -lsqlnet -lnlsrtl -lcv6 -lcore -lnlsrtl -lcv6 -lcore `cat /oracle/oracle7.16/rdbms/lib/sysliblist` -lcore -lcl -lm
ld: Invalid loader fixup needed
*** Error code 1

Stop.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <14423-5@lion>;
Sat, 22 Apr 1995 22:38:43 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Sat, 22 Apr 95 02:59:51 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa11476;
22 Apr 95 3:59 GMT-60:00
Received: by gw.home.vix.com id AA14401; Fri, 21 Apr 95 16:26:20 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA14388; Fri, 21 Apr 95 16:26:19 -0700
Received: from localhost by colossus.cse.psu.edu with SMTP id <46807>;
Fri, 21 Apr 1995 19:26:11 -0400
X-Mailer: exmh version 1.6delta 4/7/95
To: [email protected]
Subject: supported datatypes
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Fri, 21 Apr 1995 19:25:57 -0400
From: John D Groenveld <[email protected]>
Message-Id: <[email protected]>

Which Oracle datatypes are supported? I have some pro*c apps that manipulate
BLOBs and longs, which I'd like to convert to perl.
Thanks
John

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <23780-4@lion>;
Mon, 24 Apr 1995 14:39:28 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Mon, 24 Apr 95 11:51:05 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa03067;
24 Apr 95 12:50 GMT-60:00
Received: by gw.home.vix.com id AA15683; Sun, 23 Apr 95 22:27:32 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA15663; Sun, 23 Apr 95 22:27:30 -0700
Received: (from kstock@localhost) by nova.auspex.fr (8.6.9/8.6.9) id HAA00667;
Robinson France, Mon, 24 Apr 1995 07:26:45 +0200
Date: Mon, 24 Apr 1995 07:26:45 +0200
From: Kevin Stock <[email protected]>
Message-Id: <[email protected]>
To: [email protected], [email protected]
Subject: Re: supported datatypes

> Which Oracle datatypes are supported? I have some pro*c apps that manipulate
> BLOBs and longs, which I'd like to convert to perl.
> Thanks
> John
>

In Oraperl, all the non-RAW datatypes of Oracle v6 are supported. These
include LONG, but not BLOB. Tim will tell us the answer for Oracle DBI.

Kevin

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <00904-13@lion>;
Mon, 24 Apr 1995 21:39:28 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Mon, 24 Apr 95 20:17:43 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa12703;
24 Apr 95 21:16 GMT-60:00
Received: by gw.home.vix.com id AA23350; Mon, 24 Apr 95 06:55:01 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA23343; Mon, 24 Apr 95 06:54:59 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa25787;
24 Apr 95 14:39 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id ae04935;
24 Apr 95 14:39 GMT-60:00
Received: from ig.co.uk by lion id <23320-0@lion>;
Mon, 24 Apr 1995 13:45:10 +0100
To: [email protected], [email protected]
Subject: Re: Oraperl v. 2.4
Cc: [email protected]
Date: Mon, 24 Apr 1995 13:45:10 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: Kevin Stock <[email protected]>
>
> Hello Eric,
>
> > I'm trying to get oracle 7.1.4 working with perl 4.036, oraperl 2.4,
> > and sunos 4.1.4. I've linked the libraries properly, I fixed usub/mus
> > so that it looks for perl in the right place, and I've really annoyed
> > Oracle Tech support.
> >
> > Can either of you tell me what oraperl is trying to do in set_sid ?
> > Why doesn't it just leave my environment alone? Oracle_SID is set to
> > PROD, as it ought to be. Whatever it's doing, it is causing Oracle 7
> > to look in the wrong place for my database. I think that that is why
> > it freezes when I call ora_login.
> >
> > Any ideas? I'm sorry to keep cluttering your mailbox, but I'm getting
> > pretty desparate.
>
> If you pass an empty string as the first argument to &ora_login(), then
> Oraperl won't touch your environment. If you pass PROD, then it will set
> ORACLE_SID to PROD.
>
> The rules for the first argument are:
>
> if it is blank, do nothing
> otherwise, if it contains a colon, assign it to TWO_TASK
> otherwise, assign it to ORACLE_SID
>
> The rationale is that by making the ORACLE_SID an argument to &ora_login()
> instead of an environment variable, it is easier to make programs more
> robust (since they no longer rely on the environment being correct, and
> so can be used by people whose default ORACLE_SID is different) and also
> to write programs which access multiple databases.
>
DBD::Oracle does the same.

In the next version it also removes the other variable from the
environment, e.g., if it sets TWO_TASK it explicitly unsets ORACLE_SID.
This seems more robust but I'd appreciate any comments.

> Kevin
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <00903-12@lion>;
Mon, 24 Apr 1995 21:39:43 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Mon, 24 Apr 95 20:23:30 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa14496;
24 Apr 95 21:23 GMT-60:00
Received: by gw.home.vix.com id AA23337; Mon, 24 Apr 95 06:54:41 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA23333; Mon, 24 Apr 95 06:54:39 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa25793;
24 Apr 95 14:39 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id af04935;
24 Apr 95 14:39 GMT-60:00
Received: from ig.co.uk by lion id <23757-0@lion>;
Mon, 24 Apr 1995 14:37:57 +0100
To: [email protected]
Subject: Request for copies of Oracle 7.x proc/lib/proc.mk
Date: Mon, 24 Apr 1995 14:37:57 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

Currently DBD::Oracle Makefile.PL parses rdbms/lib/oracle.mk to
automatically get the right libraries to link against etc.

I'd like to switch to using the simpler and more stable proc/lib/proc.mk.

In order for this to be a smooth transition I'd appreciate it if Oracle
uses could send me ([email protected]) a copy of their proc/lib/proc.mk
files. Please include your oracle version number.

Thanks.

Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <01957-1@lion>;
Mon, 24 Apr 1995 22:44:53 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Mon, 24 Apr 95 21:24:01 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa06429;
24 Apr 95 22:23 GMT-60:00
Received: by gw.home.vix.com id AA26882; Mon, 24 Apr 95 07:44:28 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA26878; Mon, 24 Apr 95 07:44:27 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa00199;
24 Apr 95 15:41 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id ab24619;
24 Apr 95 15:41 GMT-60:00
Received: from ig.co.uk by lion id <24722-0@lion>;
Mon, 24 Apr 1995 15:39:24 +0100
To: [email protected], [email protected], [email protected]
Subject: Re: supported datatypes
Date: Mon, 24 Apr 1995 15:39:24 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: Kevin Stock <[email protected]>
>
> > Which Oracle datatypes are supported? I have some pro*c apps that manipulate
> > BLOBs and longs, which I'd like to convert to perl.
> > Thanks
> > John
>
> In Oraperl, all the non-RAW datatypes of Oracle v6 are supported. These
> include LONG, but not BLOB. Tim will tell us the answer for Oracle DBI.
>
In the short term DBD::Oracle, and hence the oraperl emulation, uses
Oracle STRING type (5) for everything (like oraperl 2.4) but does
not even consider LONGs/BLOBs etc. This is a flaw in its emulation
which I may have time to fix before the next release.

In the medium term DBD::Oracle will be *much* more type aware.

> Kevin
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <04119-4@lion>;
Tue, 25 Apr 1995 07:01:38 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 25 Apr 95 01:08:38 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa05938;
25 Apr 95 2:08 GMT-60:00
Received: by gw.home.vix.com id AA13005; Mon, 24 Apr 95 11:18:00 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA13001; Mon, 24 Apr 95 11:17:59 -0700
Received: from kadet.asic.sc.ti.com ([156.117.203.118])
by gate.ti.com (8.6.10/) with ESMTP id NAA24183
for <[email protected]>; Mon, 24 Apr 1995 13:17:57 -0500
Received: from horta.asictest.sc.ti.com (horta.asic.sc.ti.com [156.117.206.77])
by kadet.asic.sc.ti.com (8.6.7/8.6.6) with SMTP id NAA20460
for <[email protected]>; Mon, 24 Apr 1995 13:18:24 -0500
Date: Mon, 24 Apr 1995 13:18:24 -0500
From: John Sharp <[email protected]>
Message-Id: <[email protected]>
To: [email protected]
Subject: UNSUBSCRIBE

UNSUBSCRIBE
Please remove me from this mailing list.
Thanks, John.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <04119-16@lion>;
Tue, 25 Apr 1995 07:03:16 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 25 Apr 95 02:33:33 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa21253;
25 Apr 95 3:33 GMT-60:00
Received: by gw.home.vix.com id AA18972; Mon, 24 Apr 95 12:30:14 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA18860; Mon, 24 Apr 95 12:30:04 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa21250;
24 Apr 95 20:21 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa25250;
24 Apr 95 20:21 GMT-60:00
Received: from ig.co.uk by lion id <25309-0@lion>;
Mon, 24 Apr 1995 16:27:20 +0100
To: [email protected]
Subject: Re: Oraperl v. 2.4
Cc: [email protected]
Date: Mon, 24 Apr 1995 16:27:20 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: Kevin Stock <[email protected]>
>
I've CC'd this to the list in case others can contribute.

> > > > [...]
> > >
> > > If you pass an empty string as the first argument to &ora_login(), then
> > > Oraperl won't touch your environment. If you pass PROD, then it will set
> > > ORACLE_SID to PROD.
> > >
> > > The rules for the first argument are:
> > >
> > > if it is blank, do nothing
> > > otherwise, if it contains a colon, assign it to TWO_TASK
> > > otherwise, assign it to ORACLE_SID
> > >
> > > The rationale is that by making the ORACLE_SID an argument to &ora_login()
> > > instead of an environment variable, it is easier to make programs more
> > > robust (since they no longer rely on the environment being correct, and
> > > so can be used by people whose default ORACLE_SID is different) and also
> > > to write programs which access multiple databases.
> > >
> > DBD::Oracle does the same.
> >
> > In the next version it also removes the other variable from the
> > environment, e.g., if it sets TWO_TASK it explicitly unsets ORACLE_SID.
> > This seems more robust but I'd appreciate any comments.
>
> This was one of the things that needs to be revised. Someone had a
> problem because they were using networked databases whose name did
> not contain a colon.

Sounds like SQL*Net v2 or a v1 alias.

> As a result Oraperl put the name in ORACLE_SID
> when it needed to go into TWO_TASK. Maybe there's a configuration
> file somewhere that could be checked (or just check for the existence
> of $ENV{ORACLE_HOME}/$oracle_sid).
>
You mean $ENV{ORACLE_HOME}/dbs/$oracle_sid ?

Umm, how reliable/portable is that? Same issues for parsing /etc/oratab
and tnsnames.ora.

The SQL*Net v2 admin manual does not mention TWO_TASK at all. All the
examples use user/passwd@connect_descriptor form.

Perhaps we should just append $dbname to $user and $passwd with an '@'
as above...

> Kevin
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <04119-19@lion>;
Tue, 25 Apr 1995 07:03:36 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 25 Apr 95 04:17:22 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa06463;
25 Apr 95 5:16 GMT-60:00
Received: by gw.home.vix.com id AA01923; Mon, 24 Apr 95 15:38:31 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA01918; Mon, 24 Apr 95 15:38:28 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa00704;
24 Apr 95 22:45 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa13963;
24 Apr 95 22:45 GMT-60:00
Received: from ig.co.uk by lion id <01892-0@lion>;
Mon, 24 Apr 1995 22:23:16 +0100
To: [email protected]
Subject: Re: proc.mk
Date: Mon, 24 Apr 1995 22:23:16 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

Thanks to all those who have posted.

So far I've got these four versions:

proc.mk.7.24 Apr 93 Oracle 7.0.?
proc.mk.7.26 Jul 93 Oracle 7.0.15
proc.mk.7.27 Aug 93 Oracle 7.0.16
proc.mk.7.30 Feb 94 Oracle 7.1.3

If anyone has any others I'd be grateful for a copy.

Regards,
Tim.

p.s. Another DBD::Oracle version is just about ready for release.
Nothing major but many tidy-ups.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <05681-0@lion>;
Tue, 25 Apr 1995 10:13:15 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 25 Apr 95 06:47:02 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa03064;
25 Apr 95 7:46 GMT-60:00
Received: by gw.home.vix.com id AA19639; Mon, 24 Apr 95 20:31:26 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA19635; Mon, 24 Apr 95 20:31:24 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa09577;
25 Apr 95 0:45 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id ab17601;
25 Apr 95 0:45 GMT-60:00
Received: from ig.co.uk by lion id <02682-0@lion>;
Tue, 25 Apr 1995 00:44:26 +0100
To: [email protected]
Subject: Announce: DBD-Oracle-0.15.tar.Z
Date: Tue, 25 Apr 1995 00:44:26 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

Another minor update.

ftp://ftp.demon.co.uk/pub/perl/db/DBD/Oracle/DBD-Oracle-0.15.tar.Z

This one should compile cleanly and run the tests ok for everyone.

Some of the changes:

Fixed all known build problems/core dumps/truncated data etc.
Returns undef for NULLS.
Bind vars still not supported (soon I hope).
Bind vars produce errors rather than being ignored.
Login usage of ORACLE_SID and TWO_TASK slightly revised.
test.pl now uses ORACLE_SID, TWO_TASK and ORACLE_USER if defined.

Please report success or failure and detail any changes you had to make
to any of the files to get it to build and run ok.

Regards,
Tim.

p.s. The proc.mk changes will be in the next release not this one so keep
sending in your proc.mk files. Thanks.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <14740-25@lion>;
Wed, 26 Apr 1995 07:08:42 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 26 Apr 95 02:10:09 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa12789;
26 Apr 95 3:09 GMT-60:00
Received: by gw.home.vix.com id AA23200; Tue, 25 Apr 95 13:47:16 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA23195; Tue, 25 Apr 95 13:47:13 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aq02093;
25 Apr 95 19:58 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id ac17084;
25 Apr 95 19:44 GMT-60:00
Received: from ig.co.uk by lion id <12239-0@lion>;
Tue, 25 Apr 1995 18:56:09 +0100
To: [email protected], [email protected]
Subject: Re: Oraperl v. 2.4
Cc: [email protected]
Date: Tue, 25 Apr 1995 18:56:09 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: David Ferrington <[email protected]>
>
>
> Hi, it appears to me that only oracle is being discussed on this list.

Ingres should be following along shortly (in relative terms :-) ...

> If that's the case can you take me off please (i use Sybase), if not,
> when do we start talking about Sybase? :-)
>
Michael Peppler has an existing user base for his Perl5 DBlib extension
(you're probably already using it). This naturally means that Michael,
or other Sybase users, have little incentive in the short term to
implement a new interface, especially one that's not stable yet.

Once it is stable and attractive enough I'd guess that the first thing
to do would be to implement a thin DBI-to-DBlib driver 'adaptor'.

In fact, within the limits of what has been specified in the DBI spec
(such as it is), someone could implement that interface now in perl.
Volunteers?

If you still want to unsubscribe then please post a message to
[email protected] as I don't manage the list.

Regards,
Tim.

> --------------------------------------------------------------------
> | David J Ferrington |
> | IFD/IT Infrastructure Tel: +44 (0)171-711 4247 |
> | Swiss Bank Corp Fax: +44 (0)171-711 3131 |
> | London Email: [email protected] |
> --------------------------------------------------------------------

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <27322-0@lion>;
Thu, 27 Apr 1995 01:19:26 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 27 Apr 95 00:19:06 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa21401;
27 Apr 95 1:18 GMT-60:00
Received: by gw.home.vix.com id AA19944; Wed, 26 Apr 95 11:45:30 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA19938; Wed, 26 Apr 95 11:45:24 -0700
Received: from june.engin.umich.edu (june.engin.umich.edu [141.212.66.48])
by srvr7.engin.umich.edu (8.6.12/8.6.4) with SMTP id OAA21137;
Wed, 26 Apr 1995 14:43:27 -0400
Message-Id: <[email protected]>
X-Authentication-Warning: srvr7.engin.umich.edu: Host june.engin.umich.edu
didn't use HELO protocol
To: Tim Bunce <[email protected]>
Cc: [email protected], [email protected], [email protected],
[email protected]
Subject: Re: Oraperl v. 2.4
In-Reply-To: Your message of "Mon, 24 Apr 95 13:45:10 BST." <[email protected]>
Date: Wed, 26 Apr 95 14:43:26 -0400
From: Woody Kellum <[email protected]>

With SQL*Net2, you can't depend on a colon-less string being an
Oracle_SID. It may be an alias from the tnsnames.ora file that goes
in the TWO_TASK variable.
- Woody Kellum i that

> From: Kevin Stock <[email protected]>
>
> If you pass an empty string as the first argument to &ora_login(), then
> Oraperl won't touch your environment. If you pass PROD, then it will set
> ORACLE_SID to PROD.
>
> The rules for the first argument are:
>
> if it is blank, do nothing
> otherwise, if it contains a colon, assign it to TWO_TASK
> otherwise, assign it to ORACLE_SID
>
> The rationale is that by making the ORACLE_SID an argument to &ora_login()
> instead of an environment variable, it is easier to make programs more
> robust (since they no longer rely on the environment being correct, and
> so can be used by people whose default ORACLE_SID is different) and also
> to write programs which access multiple databases.
>
DBD::Oracle does the same.

In the next version it also removes the other variable from the
environment, e.g., if it sets TWO_TASK it explicitly unsets ORACLE_SID.
This seems more robust but I'd appreciate any comments.

> Kevin
>
Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <28658-1@lion>;
Thu, 27 Apr 1995 07:00:59 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 27 Apr 95 02:40:02 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa16441;
27 Apr 95 3:39 GMT-60:00
Received: by gw.home.vix.com id AA14423; Wed, 26 Apr 95 17:22:58 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA14419; Wed, 26 Apr 95 17:22:55 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa15744;
27 Apr 95 0:53 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa16138;
27 Apr 95 0:53 GMT-60:00
Received: from ig.co.uk by lion id <27158-0@lion>;
Thu, 27 Apr 1995 00:47:53 +0100
To: [email protected]
Subject: Re: Oraperl v. 2.4
Cc: [email protected], [email protected], [email protected]
Date: Thu, 27 Apr 1995 00:47:53 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: Woody Kellum <[email protected]>
>
> With SQL*Net2, you can't depend on a colon-less string being an
> Oracle_SID. It may be an alias from the tnsnames.ora file that goes
> in the TWO_TASK variable.

But can you *always* take a $dbname parameter and, rather than put it into
an env var, append it to the username/password, e.g. username/password@$dbname ?

Does that apply to V1 as well as V2 on all systems?

> - Woody Kellum

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <27975-4@lion>;
Fri, 28 Apr 1995 07:01:37 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 27 Apr 95 23:40:18 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa29585;
28 Apr 95 0:39 GMT-60:00
Received: by gw.home.vix.com id AA04922; Thu, 27 Apr 95 08:37:07 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA04918; Thu, 27 Apr 95 08:37:06 -0700
Received: from june.engin.umich.edu (june.engin.umich.edu [141.212.66.48])
by srvr7.engin.umich.edu (8.6.12/8.6.4) with SMTP id LAA14434;
Thu, 27 Apr 1995 11:36:14 -0400
Message-Id: <[email protected]>
X-Authentication-Warning: srvr7.engin.umich.edu: Host june.engin.umich.edu
didn't use HELO protocol
To: Tim Bunce <[email protected]>
Cc: [email protected], [email protected], [email protected],
[email protected], [email protected]
Subject: Re: Oraperl v. 2.4
In-Reply-To: Your message of "Thu, 27 Apr 95 00:47:53 BST." <[email protected]>
Date: Thu, 27 Apr 95 11:36:12 -0400
From: Woody Kellum <[email protected]>

I believe username/password@$dbname works the same regardless
of the SQL*Net version. My understanding is that the libs look
for the colon to determine which version of the protocol to use.
- Woody

> From: Woody Kellum <[email protected]>
>
> With SQL*Net2, you can't depend on a colon-less string being an
> Oracle_SID. It may be an alias from the tnsnames.ora file that goes
> in the TWO_TASK variable.

But can you *always* take a $dbname parameter and, rather than put it into
an env var, append it to the username/password, e.g. username/password@$dbname ?

Does that apply to V1 as well as V2 on all systems?

> - Woody Kellum

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <08469-2@lion>;
Sat, 29 Apr 1995 01:01:20 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Fri, 28 Apr 95 23:29:11 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa29556;
29 Apr 95 0:28 GMT-60:00
Received: by gw.home.vix.com id AA03243; Fri, 28 Apr 95 07:18:30 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA03239; Fri, 28 Apr 95 07:18:28 -0700
Received: by q.osmre.gov (931110.SGI/921111.SGI.AUTO)
for [email protected] id AA15588; Fri, 28 Apr 95 08:12:03 -0600
From: Bill Kannawin <[email protected]>
Message-Id: <[email protected]>
Date: Fri, 28 Apr 1995 08:11:47 -0600
X-Mailer: Z-Mail (3.1.0 22feb94 MediaMail)
To: [email protected]
Subject: Subcribe
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0

ADD [email protected]

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <18458-31@lion>;
Wed, 3 May 1995 07:10:35 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 03 May 95 00:41:11 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa19499;
3 May 95 1:40 GMT-60:00
Received: by gw.home.vix.com id AA18234; Tue, 2 May 95 12:17:06 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA18189; Tue, 2 May 95 12:16:39 -0700
Received: from mogate (mogate.sps.mot.com)
by spsgate.sps.mot.com (4.1/SMI-4.1/Email 2.1 10/25/93) id AA03880
for [email protected]; Tue, 2 May 95 12:16:30 MST
Received: from emailchd by mogate (4.1/SMI-4.1/Email-2.0) id AA03933;
Tue, 2 May 95 12:16:29 MST
Received: by newton.sps.mot.com.sps.mot.com (4.1/SMI-4.1) id AA07620;
Tue, 2 May 95 12:12:55 MST
Date: Tue, 2 May 95 12:12:55 MST
From: David Thornewill von Essen <[email protected]>
Message-Id: <[email protected]>
To: [email protected]
Subject: Precompiled Isqlperl

Hi,

Does someone have a precompiled version of isqlperl for Solaris 2.3 available?
I presume that this will work on my machine if everything else is pretty much
in st's standard place. Unfortunately I don't have a copy of ESQL, and the
ordering cycle here can take a while :-( and I need to do some stuff right
away.

Regards,
David TvE
--
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
! David Thornewill von Essen tel: (602) 814-4395 !
! Motorola LATG Operations MD: CH285/AZ50 fax: (602) 814-4451 !
! Chandler, AZ-85224 Pager: 1-800-407-9601 !
+-------------------------------------------------------------------+
! 'At times we must engage an act of faith that key !
! things are doable that are not provable' -- Bob Galvin !
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <14949-27@lion>;
Tue, 9 May 1995 07:06:19 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 09 May 95 02:04:21 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa17288;
9 May 95 3:04 GMT-60:00
Received: by gw.home.vix.com id AA14834; Mon, 8 May 95 09:17:28 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA14830; Mon, 8 May 95 09:17:26 -0700
Received: from dblab.inf.ethz.ch ([email protected] [129.132.101.53])
by inf.ethz.ch (8.6.10/8.6.10) with ESMTP id QAA01223
for <[email protected]>; Mon, 8 May 1995 16:03:58 +0200
Received: from apdbs1.ethz.ch (apdbs1 [129.132.14.42])
by dblab.inf.ethz.ch (8.6.10/8.6.9) with ESMTP id PAA18075
for <[email protected]>; Mon, 8 May 1995 15:49:07 +0200
From: Tomas Felner <[email protected]>
Received: (felner@localhost) by apdbs1.ethz.ch (8.6.10/8.6.9) id PAA07347
for [email protected]; Mon, 8 May 1995 15:49:55 +0200
Message-Id: <[email protected]>
Subject: DBD-Oracle-0.15 & Solaris 2.3
To: [email protected]
Date: Mon, 8 May 1995 15:49:53 +0200 (MET DST)
X-Mailer: ELM [version 2.4 PL23]
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Content-Length: 2989

Hello everybody!

I'm new to the list so please forgive if the following has been discussed
already. I am trying to install DBD-Oracle-0.15 on my Solaris 2.3 box.
Compilation works but the subsequent test fails. Below is the detailed info.
I also compiled everything (perl5, DBI & DBD) with the SPARCcompiler, same
results. Any hints? Thanks.

- Tom

(dblab4:933)# perl Makefile.PL
Configuring DBD::Oracle version 0.15...
Using Oracle in /opt/oracle/product/7.1.3
Using oracle.mk version 7.76
Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio
System: perl5.001 sunos dblab4 5.3 generic_101318-68 sun4d sparc gcc -O
See README notes about SPARCompiler on Solaris
Writing Makefile for DBD::Oracle

(dblab4:934)# make
mkdir /opt/src/perldb/Oracle/blib
mkdir /opt/src/perldb/Oracle/blib/DBD
mkdir /opt/src/perldb/Oracle/blib/auto
mkdir /opt/src/perldb/Oracle/blib/auto/DBD
mkdir /opt/src/perldb/Oracle/blib/auto/DBD/Oracle
/opt/bin/perl /opt/lib/perl5/ExtUtils/xsubpp -typemap
/opt/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc Oracle.c
gcc -c -O -fpic -I/opt/lib/perl5/sun4-solaris/CORE -Wall -Wno-comment -Wpointer-arith -Wcast-align -Wconversion -I/opt/oracle/product/7.1.3/rdbms/demo -I/opt/lib/perl5/sun4-solaris/DBI Oracle.c
Running mkbootstrap for DBD::Oracle ()
ld -o /opt/src/perldb/Oracle/blib/auto/DBD/Oracle/Oracle.so -G Oracle.o -L/opt/oracle/product/7.1.3/lib /opt/oracle/product/7.1.3/lib/crti.o /opt/oracle/product/7.1.3/lib/crt1.o /opt/oracle/product/7.1.3/lib/__fstd.o /opt/oracle/product/7.1.3/lib/libocic.a /opt/oracle/product/7.1.3/lib/osntab.o -lsqlnet -lora -lsqlnet -lora -lnlsrtl -lcv6 -lcore -lnlsrtl -lcv6 -lcore `cat /opt/oracle/product/7.1.3/rdbms/lib/sysliblist` -lcore -lsocket -lnsl -lm -ldl -laio
cp Oracle.bs /opt/src/perldb/Oracle/blib/auto/DBD/Oracle/Oracle.bs
cp Oraperl.pm /opt/src/perldb/Oracle/blib/Oraperl.pm
cp Oracle.pm /opt/src/perldb/Oracle/blib/DBD/Oracle.pm

(dblab4:935)# make test
/opt/bin/perl -I/opt/src/perldb/Oracle/blib -I/opt/src/perldb/Oracle/blib
-I/opt/lib/perl5/sun4-solaris -I/opt/lib/perl5 -e 'use Test::Harness
qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/base..............FAILED on test 0
t/main..............ok
Failed 1 test, 50.00% okay.
Files=1, Tests=1, 3 secs ( 1.88 cusr 0.88 csys = 2.76 cpu)
/opt/bin/perl -I/opt/src/perldb/Oracle/blib -I/opt/src/perldb/Oracle/blib
-I/opt/lib/perl5/sun4-solaris -I/opt/lib/perl5 test.pl
Oraperl test application $Revision: 1.5 $
make: *** [test] Illegal Instruction

////
(. .)
+-------------------oOO-(_)-OOo----------------------------------+
| Tomas Felner ([email protected]) -- System & DB Administrator |
| Phone: +41-1-632-7253 Fax: +41-1-632-1172 |
| Institute for Informationsystems, Database Group, IFW C 48.1 |
| Haldeneggsteig 4, ETH Zentrum, CH - 8092 Zurich, Switzerland |
+----------------------------------------------------------------+

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <28991-2@lion>;
Wed, 10 May 1995 07:01:15 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 09 May 95 20:39:54 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa01451;
9 May 95 21:39 GMT-60:00
Received: by gw.home.vix.com id AA00414; Tue, 9 May 95 08:10:25 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA00410; Tue, 9 May 95 08:10:24 -0700
Received: by netcom16.netcom.com (8.6.12/Netcom) id IAA20730;
Tue, 9 May 1995 08:08:48 -0700
From: Greg Balfanz <[email protected]>
Message-Id: <[email protected]>
Subject: subscribe
To: [email protected]
Date: Tue, 9 May 1995 08:08:48 -0700 (PDT)
X-Mailer: ELM [version 2.4 PL23]
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 747

subscribe
--
World-Wide-Web address <http://www.saa.com/greg>

\|/ Greg Balfanz WB1ACJ
/\ -O- [email protected]
/ \ /|\ Boerne, TX
/ \ /\
/ \ / \ Deep in the heart of Texas hill country
/ /\ / \ /\ /\ /\ /\ /\/\/\ /\
/ / \ / \ / \/\/ \/ \ /\/ \/\ /\ /\/ / / \/ \
/ / \/ /\ \ / \ \ / \/ / / \/ \/ \ / \ \
/ / \/ \/\ \ / \ / / \
__/__/_______/___/__\___\__________________________________________________

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <28989-11@lion>;
Wed, 10 May 1995 07:02:56 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 09 May 95 21:16:46 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa12147;
9 May 95 22:16 GMT-60:00
Received: by gw.home.vix.com id AA09632; Tue, 9 May 95 10:43:10 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA09628; Tue, 9 May 95 10:43:08 -0700
Received: from msi-gateway1.metropolis.com
by gaia.internex.net (SMI-8.6.9/SMI-SVR4) id KAA06067;
Tue, 9 May 1995 10:43:05 -0700
Received: by msi-gateway1.metropolis.com (IBM OS/2 SENDMAIL VERSION 1.3.2)/1.1)
id AA8868; Tue, 09 May 95 10:46:35 -0700
Message-Id: <[email protected]>
Received: from MSI Notes Network with "Lotus Notes Mail Gateway for SMTP"
id C80C53BF73CF447F882561B70060B8B2; Tue, 9 May 95 10:46:26
To: felner <[email protected]>
Cc: perldb-interest <[email protected]>
From: David Moellenhoff/MSI <[email protected]>
Date: 9 May 95 10:41:54 EDT
Subject: Re: DBD-Oracle-0.15 & Solaris 2.3
Mime-Version: 1.0
Content-Type: Text/Plain

> From: Tomas Felner <[email protected]>
>
> Hello everybody!
>
> I'm new to the list so please forgive if the following has been discussed
> already. I am trying to install DBD-Oracle-0.15 on my Solaris 2.3 box.
> Compilation works but the subsequent test fails. Below is the detailed info.
> I also compiled everything (perl5, DBI & DBD) with the SPARCcompiler, same
> results. Any hints? Thanks.
>
> - Tom
>
> (dblab4:933)# perl Makefile.PL
> Configuring DBD::Oracle version 0.15...
> Using Oracle in /opt/oracle/product/7.1.3
> Using oracle.mk version 7.76
> Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio
> System: perl5.001 sunos dblab4 5.3 generic_101318-68 sun4d sparc gcc -O
> See README notes about SPARCompiler on Solaris
> Writing Makefile for DBD::Oracle

> (dblab4:934)# make
> /opt/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc Oracle.c
> gcc -c -O -fpic -I/opt/lib/perl5/sun4-solaris/CORE -Wall -Wno-comment
-Wpointer-arith -Wcast-align -Wconversion -I/opt/oracle/product/7.1.3/rdbms/dem
o -I/opt/lib/perl5/sun4-solaris/DBI Oracle.c
> ld -o /opt/src/perldb/Oracle/blib/auto/DBD/Oracle/Oracle.so -G Oracle.o
-L/opt/oracle/product/7.1.3/lib /opt/oracle/product/7.1.3/lib/crti.o
/opt/oracle/product/7.1.3/lib/crt1.o /opt/oracle/product/7.1.3/lib/__fstd.o
/opt/oracle/product/7.1.3/lib/libocic.a /opt/oracle/product/7.1.3/lib/osntab.o
-lsqlnet -lora -lsqlnet -lora -lnlsrtl -lcv6 -lcore -lnlsrtl -lcv6
-lcore `cat /opt/oracle/product/7.1.3/rdbms/lib/sysliblist` -lcore -lsocket
-lnsl -lm -ldl -laio

> (dblab4:935)# make test
> /opt/bin/perl -I/opt/src/perldb/Oracle/blib -I/opt/src/perldb/Oracle/blib
> -I/opt/lib/perl5/sun4-solaris -I/opt/lib/perl5 -e 'use Test::Harness
> qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> t/base..............FAILED on test 0
> t/main..............ok
> Failed 1 test, 50.00% okay.
> Files=1, Tests=1, 3 secs ( 1.88 cusr 0.88 csys = 2.76 cpu)
> /opt/bin/perl -I/opt/src/perldb/Oracle/blib -I/opt/src/perldb/Oracle/blib
> -I/opt/lib/perl5/sun4-solaris -I/opt/lib/perl5 test.pl
> Oraperl test application $Revision: 1.5 $
> make: *** [test] Illegal Instruction
>

Try editing your oracle.mk (or Makefile) file and removing the
$ORACLE_HOME/lib/crti.o and $ORACLE_HOME/lib/crt1.o from the COMPOBJS= line.
Your compiler should know how to resolve these symbols somewhere else. I had
the same core dumping problem with Solaris 2.3 and Oracle 7.1.3. Removing
these two libraries from Oracle.so solved the problem.

-Dave

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <28991-17@lion>;
Wed, 10 May 1995 07:03:42 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 09 May 95 21:53:55 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa22607;
9 May 95 22:53 GMT-60:00
Received: by gw.home.vix.com id AA24409; Tue, 9 May 95 06:25:45 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA24401; Tue, 9 May 95 06:25:41 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa12073;
9 May 95 14:18 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id ac15423;
9 May 95 14:18 GMT-60:00
Received: from ig.co.uk by lion id <21737-0@lion>;
Tue, 9 May 1995 13:59:29 +0100
To: [email protected], [email protected]
Subject: Re: DBD-Oracle-0.15 & Solaris 2.3
Date: Tue, 9 May 1995 13:59:29 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: Tomas Felner <[email protected]>
>
> Hello everybody!
>
> I'm new to the list so please forgive if the following has been discussed
> already. I am trying to install DBD-Oracle-0.15 on my Solaris 2.3 box.
> Compilation works but the subsequent test fails. Below is the detailed info.
> I also compiled everything (perl5, DBI & DBD) with the SPARCcompiler, same
> results. Any hints? Thanks.
>
> - Tom
>
> (dblab4:933)# perl Makefile.PL
> Configuring DBD::Oracle version 0.15...
> Using Oracle in /opt/oracle/product/7.1.3
> Using oracle.mk version 7.76
> Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio
> System: perl5.001 sunos dblab4 5.3 generic_101318-68 sun4d sparc gcc -O
> See README notes about SPARCompiler on Solaris
> Writing Makefile for DBD::Oracle

> (dblab4:934)# make
> /opt/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc Oracle.c
> gcc -c -O -fpic -I/opt/lib/perl5/sun4-solaris/CORE -Wall -Wno-comment -Wpointer-arith -Wcast-align -Wconversion -I/opt/oracle/product/7.1.3/rdbms/demo -I/opt/lib/perl5/sun4-solaris/DBI Oracle.c
> ld -o /opt/src/perldb/Oracle/blib/auto/DBD/Oracle/Oracle.so -G Oracle.o -L/opt/oracle/product/7.1.3/lib /opt/oracle/product/7.1.3/lib/crti.o /opt/oracle/product/7.1.3/lib/crt1.o /opt/oracle/product/7.1.3/lib/__fstd.o /opt/oracle/product/7.1.3/lib/libocic.a /opt/oracle/product/7.1.3/lib/osntab.o -lsqlnet -lora -lsqlnet -lora -lnlsrtl -lcv6 -lcore -lnlsrtl -lcv6 -lcore `cat /opt/oracle/product/7.1.3/rdbms/lib/sysliblist` -lcore -lsocket -lnsl -lm -ldl -laio

> (dblab4:935)# make test
> /opt/bin/perl -I/opt/src/perldb/Oracle/blib -I/opt/src/perldb/Oracle/blib
> -I/opt/lib/perl5/sun4-solaris -I/opt/lib/perl5 -e 'use Test::Harness
> qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
> t/base..............FAILED on test 0
> t/main..............ok
> Failed 1 test, 50.00% okay.
> Files=1, Tests=1, 3 secs ( 1.88 cusr 0.88 csys = 2.76 cpu)
> /opt/bin/perl -I/opt/src/perldb/Oracle/blib -I/opt/src/perldb/Oracle/blib
> -I/opt/lib/perl5/sun4-solaris -I/opt/lib/perl5 test.pl
> Oraperl test application $Revision: 1.5 $
> make: *** [test] Illegal Instruction
>
Strange indeed. Especially that t/base failed but t/main passed! I
haven't built on Solaris 2 for a while. I'll have a go if I get some time.

Please email me what you get from doing a: make test TEST_VERBOSE=1
If you get a core dump please include a stack dump from it. Please
also post the output of perl -e 'use Config; print Config::myconfig()'
as per the instructions in the README file.

Please also try building the OCI demos under /opt/oracle/product/7.1.3/proc
just to prove that all is well with your OCI/Pro*C installation.

Ideas from anyone else gladly accepted.

Thanks.

Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <10486-0@lion>;
Thu, 11 May 1995 07:01:45 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 10 May 95 17:03:05 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa03773;
10 May 95 18:02 GMT-60:00
Received: by gw.home.vix.com id AA28383; Wed, 10 May 95 00:12:50 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA28379; Wed, 10 May 95 00:12:48 -0700
Received: from dblab.inf.ethz.ch ([email protected] [129.132.101.53])
by inf.ethz.ch (8.6.10/8.6.10) with ESMTP id JAA01043;
Wed, 10 May 1995 09:12:39 +0200
Received: from apdbs1.ethz.ch (apdbs1 [129.132.14.42])
by dblab.inf.ethz.ch (8.6.10/8.6.9) with ESMTP id JAA27781;
Wed, 10 May 1995 09:12:34 +0200
From: Tomas Felner <[email protected]>
Received: (felner@localhost) by apdbs1.ethz.ch (8.6.10/8.6.9) id JAA10311;
Wed, 10 May 1995 09:12:31 +0200
Message-Id: <[email protected]>
Subject: Re: DBD-Oracle-0.15 & Solaris 2.3
To: David Moellenhoff/MSI <[email protected]>
Date: Wed, 10 May 1995 09:12:28 +0200 (MET DST)
Cc: [email protected]
In-Reply-To: <[email protected]> from "David Moellenhoff/MSI" at May 9, 95 10:41:54 am
X-Mailer: ELM [version 2.4 PL23]
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Content-Length: 1367

David Moellenhoff/MSI says:
>
> Try editing your oracle.mk (or Makefile) file and removing the
> $ORACLE_HOME/lib/crti.o and $ORACLE_HOME/lib/crt1.o from the COMPOBJS= line.
> Your compiler should know how to resolve these symbols somewhere else. I had
> the same core dumping problem with Solaris 2.3 and Oracle 7.1.3. Removing
> these two libraries from Oracle.so solved the problem.

Thanks, that did the trick! In the README that comes with DBD-Oracle, there
is a note at the end about Sun's SPARCcompiler having a problem with exactly
those two files. I ignored it since I used gcc. I also tried to compile
everything with the SPARCcompiler but I didn't get the linking errors
described in the README.

As it looks now, the above two files seem to cause trouble with any
compiler, or at least with Suns and gcc. Any other experiences with that?

Thanks to Tim and David for their help!

- Tom
////
(. .)
+-------------------oOO-(_)-OOo----------------------------------+
| Tomas Felner ([email protected]) -- System & DB Administrator |
| Phone: +41-1-632-7253 Fax: +41-1-632-1172 |
| Institute for Informationsystems, Database Group, IFW C 48.1 |
| Haldeneggsteig 4, ETH Zentrum, CH - 8092 Zurich, Switzerland |
+----------------------------------------------------------------+

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <10487-21@lion>;
Thu, 11 May 1995 07:05:14 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 10 May 95 18:38:14 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa07108;
10 May 95 19:37 GMT-60:00
Received: by gw.home.vix.com id AA13854; Wed, 10 May 95 03:29:30 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA13850; Wed, 10 May 95 03:29:29 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa04806;
10 May 95 11:14 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id ac01773;
10 May 95 11:14 GMT-60:00
Received: from ig.co.uk by lion id <00872-0@lion>;
Wed, 10 May 1995 10:26:43 +0100
To: [email protected], [email protected]
Subject: Re: DBD-Oracle-0.15 & Solaris 2.3
Cc: [email protected]
Date: Wed, 10 May 1995 10:26:43 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: David Moellenhoff/MSI <[email protected]>
>
> > [...]
> > /opt/bin/perl -I/opt/src/perldb/Oracle/blib -I/opt/src/perldb/Oracle/blib
> > -I/opt/lib/perl5/sun4-solaris -I/opt/lib/perl5 test.pl
> > Oraperl test application $Revision: 1.5 $
> > make: *** [test] Illegal Instruction
> >
>
> Try editing your oracle.mk (or Makefile) file and removing the
> $ORACLE_HOME/lib/crti.o and $ORACLE_HOME/lib/crt1.o from the COMPOBJS= line.
> Your compiler should know how to resolve these symbols somewhere else. I had
> the same core dumping problem with Solaris 2.3 and Oracle 7.1.3. Removing
> these two libraries from Oracle.so solved the problem.
>
Was your core dump from an Illegal Instruction?

> -Dave
>
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <10486-48@lion>;
Thu, 11 May 1995 07:08:05 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 10 May 95 22:30:59 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa09908;
10 May 95 23:30 GMT-60:00
Received: by gw.home.vix.com id AA01136; Wed, 10 May 95 09:27:52 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA01131; Wed, 10 May 95 09:27:49 -0700
Received: from msi-gateway1.metropolis.com
by gaia.internex.net (SMI-8.6.9/SMI-SVR4) id JAA13542;
Wed, 10 May 1995 09:27:47 -0700
Received: by msi-gateway1.metropolis.com (IBM OS/2 SENDMAIL VERSION 1.3.2)/1.1)
id AA9146; Wed, 10 May 95 09:31:24 -0700
Message-Id: <[email protected]>
Received: from MSI Notes Network with "Lotus Notes Mail Gateway for SMTP"
id D4B91ED591354474882561B80057469D; Wed, 10 May 95 09:31:08
To: Tim Bunce <[email protected]>
Cc: perldb-interest <[email protected]>
From: David Moellenhoff/MSI <[email protected]>
Date: 10 May 95 9:26:19 EDT
Subject: Re: DBD-Oracle-0.15 & Solaris 2.3
Mime-Version: 1.0
Content-Type: Text/Plain

>> From: David Moellenhoff/MSI <[email protected]>
>>
>> > [...]
>> > /opt/bin/perl -I/opt/src/perldb/Oracle/blib -I/opt/src/perldb/Oracle/blib
>> > -I/opt/lib/perl5/sun4-solaris -I/opt/lib/perl5 test.pl
>> > Oraperl test application $Revision: 1.5 $
>> > make: *** [test] Illegal Instruction
>> >
>>
>> Try editing your oracle.mk (or Makefile) file and removing the
>> $ORACLE_HOME/lib/crti.o and $ORACLE_HOME/lib/crt1.o from the COMPOBJS=
line.
>> Your compiler should know how to resolve these symbols somewhere else. I
had
>> the same core dumping problem with Solaris 2.3 and Oracle 7.1.3. Removing
>> these two libraries from Oracle.so solved the problem.
>>
>Was your core dump from an Illegal Instruction?
>
>> -Dave
>>
>Tim.

I had the same problem as Tomas. I used gcc to compile perl, DBI and DBD-ORACLE
and got the illegal instruction core dump when the Oracle.so was opened.
Tracing
with gdb found the illegal instruction was comming from within the dlopen()
library
routine. The first call to dlopen() opened the DBI.so and that call worked
fine. The
second call tried to open Oracle.so and the illegal instruction occurred. I
tried this
little program:

#include <dlfcn.h>
#include <stdlib.h>
#include <stdio.h>

void main() {

if(!dlopen("blib/auto/DBD/Oracle/Oracle.so",RTLD_NOW)) puts(dlerror());
}

This program didn't core dump but did give an error message from dlerror().
I think it had something to do with symbols not resolving, but as my Oracle.so
works now, I can't replicate it.

-Dave

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <10487-48@lion>;
Thu, 11 May 1995 07:08:50 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 10 May 95 23:16:22 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa22105;
11 May 95 0:15 GMT-60:00
Received: by gw.home.vix.com id AA25597; Wed, 10 May 95 07:36:33 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA25592; Wed, 10 May 95 07:36:21 -0700
Received: from worf.fuentez.com (worf.fuentez.com [192.246.52.76])
by beaker.fuentez.com (8.6.12/8.6.12) with ESMTP id KAA24043
for <[email protected]>; Wed, 10 May 1995 10:35:39 -0400
From: Joe Hildebrand <[email protected]>
Received: (hildjj@localhost) by worf.fuentez.com (8.6.9/8.6.9) id KAA18928;
Wed, 10 May 1995 10:36:35 -0400
Date: Wed, 10 May 1995 10:36:35 -0400
Message-Id: <[email protected]>
To: [email protected]
In-Reply-To: Tomas Felner's message of Wed, 10 May 1995 09:12:28 +0200 (MET DST)
Subject: Re: DBD-Oracle-0.15 & Solaris 2.3
Reply-To: [email protected]
References: <[email protected]>

> "Tomas" == Tomas Felner <[email protected]> writes:

Tomas> As it looks now, the above two files seem to cause trouble
Tomas> with any compiler, or at least with Suns and gcc. Any other
Tomas> experiences with that?

I finally got rid of the core dumps, as well. Now, I get the error
that was causing do_error to be called:

ERROR EVENT: DBI::st=HASH(0x21c564)->DBI::default_handler(1041
ORA-01041: internal error. hostdef extension doesn't exist)

Is this something I should be worried about?

--
Joe Hildebrand Fuentez Systems Concepts
[email protected] 11781 Lee-Jackson Hwy, Suite 700
Lead Software Engineer Fairfax, VA 22033
Phone: (703)273-1447
Fax: (703)273-2972
PGPprint: 0x06C96661

Standard disclaimers apply

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <06571-0@lion>;
Fri, 12 May 1995 22:57:11 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Fri, 12 May 95 21:55:10 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa26018;
12 May 95 22:54 GMT-60:00
Received: by gw.home.vix.com id AA24776; Fri, 12 May 95 10:02:05 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA24748; Fri, 12 May 95 10:00:44 -0700
Received: from sbi.com by uu5.psi.com (5.65b/4.0.071791-PSI/PSINet) via SMTP;
id AA17325 for [email protected]; Fri, 12 May 95 12:50:46 -0400
Received: from sbi.com (uss) by internet.sbi.com (4.1/SMI-4.1) id AA18400;
Fri, 12 May 95 12:50:18 EDT
Received: from harley.sbi.com by sbi.com (5.x/SMI-SVR4) id AA14368;
Fri, 12 May 1995 12:50:10 -0400
Received: by harley.sbi.com (5.x/SMI-SVR4) id AA07963;
Fri, 12 May 1995 12:51:20 -0400
Date: Fri, 12 May 1995 12:51:20 -0400
From: Judith Meng <[email protected]>
Message-Id: <[email protected]>
To: [email protected], [email protected]
Subject: DBI and Sybase
Cc: [email protected], [email protected]
X-Sun-Charset: US-ASCII

Hello,

I am interested the database-independant perl interface to relational
databases (DBI) and the database-specific driver to Sybase (DBD?).

Could you provide me with these modules and/or more information.
I understand there are some other Sybase-specific
modules that I might also need.

Judith C. Meng
Salomon Inc.
UNIX Systems Support
[email protected]
(201) 896-7190

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <26861-4@lion>;
Wed, 17 May 1995 07:03:44 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 17 May 95 01:41:42 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa16298;
17 May 95 2:41 GMT-60:00
Received: by gw.home.vix.com id AA16708; Tue, 16 May 95 13:50:47 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA16704; Tue, 16 May 95 13:50:45 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa22786;
16 May 95 21:39 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa01848;
16 May 95 21:38 GMT-60:00
Received: from ig.co.uk by lion id <23934-0@lion>;
Tue, 16 May 1995 21:38:21 +0100
To: [email protected]
Subject: Quick note about DBD::Oracle progress
Date: Tue, 16 May 1995 21:38:21 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

I just thought you'd like to know that I hope to make another DBD::Oracle
release in a few days (but don't quote me on that ;-).

Current status:

Makefile.PL now uses $ORACLE_HOME/proc/lib/proc.mk
it also edits COMPOBJS for Solaris+GCC.

connect now uses ...@$dbname method and no longer mucks
about with ORACLE_SID or TWO_TASK

ora_long and ora_trunc work _internally_ but I've yet to
implement the association with Oraperl::ora_long etc.

bind variables work _internally_ but I've yet to implement
the interface (I'll probably post more on this later
because there are some outstanding issues here).

oraperl emulation is faster (especially fetch).

ora_autocommit works.

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <26861-5@lion>;
Wed, 17 May 1995 07:04:06 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 17 May 95 02:31:38 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa23067;
17 May 95 3:30 GMT-60:00
Received: by gw.home.vix.com id AA25275; Tue, 16 May 95 16:28:58 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA25270; Tue, 16 May 95 16:28:56 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa01118;
16 May 95 23:37 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa09491;
16 May 95 23:37 GMT-60:00
Received: from ig.co.uk by lion id <25758-0@lion>;
Tue, 16 May 1995 23:37:20 +0100
To: [email protected]
Subject: Interface to bind variables - important design issues
Date: Tue, 16 May 1995 23:37:20 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

THE BASIC SCENARIO:

$sth = $dbh->prepare("select foo from bar where baz > ? and boo < ?");
# or baz > :1 for oracle users
$sth->execute($baz_value, $boo_value);

while (@row = $sth->fetchrow) { ... }

That's fine as far as it goes but it doesn't actually go very far.

Specifically it does not address any of these issues:

- Named parameters
- Array parameters (to stored procedures etc)
- Output parameters (from stored procedures etc)

Whilst the main driving force behind these issues is the Oracle driver
I think they will all apply, sooner or later, to other drivers.

I'll consider each of these in turn...

* NAMED PARAMETERS

It is typically possible to use '?' (and/or ':1' for oracle) to specify
placeholders in the statement being prepared for values to be bound in later.

In some situations, such as invoking stored procedures, it may be
necessary to use named placeholders to bind to named procedure parameters.

The DBI interface needs to provide some mechanism for this.

* ARRAY PARAMETERS

Some databases are able to support the passing of arrays of values as
parameters to stored procedures or for executing a statement (eg insert)
multiple times. For Perl5 this maps neatly onto passing a list reference.

* OUTPUT PARAMETERS

Once again this relates mainly to stored procedures. Ideally it should be
possible for a statement being executed to output/update the values bound
to its placeholders. This implies using references for both arrays and
scalar variables.

DESIGN ISSUES AND PROPOSALS

The primary goal here is to:

Keep simple things simple but make complicated things possible.

For bind variables this translates into keeping the existing simple

$sth->execute($baz_value, $boo_value);

interface for the common simple case. This will, as now, bind the
variables in left-to-right order to the corresponding unnamed placeholders.
Using this form for a statement containing named placeholders would
generate an error.

The names, or sequence numbers

If you want to do anything fancy with bind variables you'll need to call
a new method 'bindparam' (for which a possible interface is described below).

The execute method would still be used to execute the statement but would be
called without any parameters. Mixing calls to bind() with using parameters
to execute() for the same statement would generate an error.

It's interesting to note that this approach will allow execute to be called
many times without the overhead of rebinding all the parameters every time.

If you have any comments about the above please keep them separate from
comments about the bind method interface outlined below.

The new bindparam method:

$sth->bindparam($name, \$value, \%attr, [, ...]);

$name -- the name, or sequence number, of the placeholder to be bound.
\$value -- a reference to the scalar or array containing the value.
\%attr -- optional attributes as a hash ref or undef.

Multiple values can be bound with one call by repeating the three parameters.

The method is called bindparam to match the corresponding X/Open & SAG
standard function BindParam() and to leave the way clear to define other
bind*() methods such as bindcol (corresponding to the BindCol() function).

All comments very welcome.

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <16621-1@lion>;
Mon, 22 May 1995 07:01:24 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Sat, 20 May 95 03:44:57 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa05735;
20 May 95 4:44 GMT-60:00
Received: by gw.home.vix.com id AA09649; Fri, 19 May 95 18:44:35 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA09640; Fri, 19 May 95 18:44:34 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa07637;
20 May 95 2:31 GMT-60:00
Received: from ignite.demon.co.uk by post.demon.co.uk id aa09933;
20 May 95 2:31 GMT-60:00
Received: from ig.co.uk by lion id <10115-0@lion>;
Sat, 20 May 1995 02:31:46 +0100
To: [email protected]
Subject: Announce: DBD-Oracle-0.15.tar.Z: Bind variables work!
Date: Sat, 20 May 1995 02:31:46 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

Major changes:

ora_bind now works!

ora_autocommit works.

ora_long and ora_trunc now work. Their values are stored in the cursor
each time ora_open is called. Is that okay for everyone?

oraperl emulation is faster in general (especially fetch).

Makefile.PL now uses $ORACLE_HOME/proc/lib/proc.mk
it also edits COMPOBJS for Solaris+GCC.

connect now uses ...@$dbname method if $dbname contains a colon.
Sadly the ...@$dbname method does not work for non sqlnet connection.
We still need a solution to this. Configuration details and suggestions
from people who are affected are most welcome.

This is a fairly major code revision, expect teething problems.

With regard to bind variables... I've not actually done much stress
testing, remember, this is still alpha software! I'd very much like to
know how well it works for you.

I have not yet implemented the bindparam() method etc as discussed in
my previous message. I've only done enough to enhance the Oraperl
emulation. You may be interested to know that I've been able to support
':1', ':name' and '?' style placeholders. I do this by editing the
statement to replace the ':1' or '?' styles by ':p1', ':p2', ':p3'
etc. This allows be to use the OCI obndrv function (I'll use obdnra later).
If you want to play with this you should now be able to write
PL/SQL blocks with :p1 style placeholders and bind values using
&ora_bind(). If you do please let me know how it goes.

The Oraperl emulation functionality is getting close to beta levels!

Please, please, please, try this release and tell me about *anything*
and *everything* you needed to do to get it to work on your platform
with your compiler.

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <16619-19@lion>;
Mon, 22 May 1995 07:07:04 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Sun, 21 May 95 21:43:44 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa01055;
21 May 95 22:42 +0100
Received: by gw.home.vix.com id AA14371; Sun, 21 May 95 12:13:05 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA14364; Sun, 21 May 95 12:12:57 -0700
Received: from css96.CV.COM (css96.CV.COM [130.21.232.96])
by uk.cv.com (8.6.9/251194/UK) with SMTP id UAA09264;
Sun, 21 May 1995 20:01:01 +0100
Received: from css90.CV.COM by css96.CV.COM (4.1/SMI-4.1) id AA03318;
Sun, 21 May 95 21:11:22 +0200
Errors-To: krm%[email protected]
Received: from cobra.cv.com by css90.CV.COM (4.0/SMI-4.0) id AA11866;
Sun, 21 May 95 21:19:32 +0200
Errors-To: krm%[email protected]
Received: by cobra.cv.com (4.1/SMI-4.1) id AA03848;
Sun, 21 May 95 21:12:48 +0200
Date: Sun, 21 May 95 21:12:48 +0200
From: Martin {martlbub} Kraegeloh <mkr%[email protected]>
Message-Id: <[email protected]>
Errors-To: krm%[email protected]
Reply-To: krm%[email protected]
Return-Receipt-To: krm%[email protected]
Errors-To: krm%[email protected]
To: [email protected], [email protected]
Subject: browser for database table needed

Hi,

before starting to write something from scratch, I'd like to make sure
that what I need does'nt exist (which would be the sad case :-( )

Basically I want to be able to say "create a presenter for table xyz",
which will result in a horizontally and vertically scrollable matrix
showing the table's rows. (using pTk)

Column headings should be taken from the data dict of the database,
and options should allow to define which function buttons to include etc.

If I don't find something, I might start writing it; in this case I will
create a spec and post it here to gather input concerning the functionality
others might want to have in there ...

Martin Kraegeloh

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <00873-6@lion>;
Mon, 22 May 1995 22:59:08 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Mon, 22 May 95 20:34:35 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa15027;
22 May 95 21:33 +0100
Received: by gw.home.vix.com id AA26193; Mon, 22 May 95 09:22:39 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA26129; Mon, 22 May 95 09:22:34 -0700
Received: from gonzales.compulink.co.uk (gonzales.compulink.co.uk [192.188.69.4])
by tom.compulink.co.uk (8.6.9/8.6.9) id RAA17254
for [email protected]; Mon, 22 May 1995 17:22:30 +0100
Date: Mon, 22 May 95 17:22 BST-1
From: Alan Burlison <[email protected]>
Subject: Porting DBI & Oraperl to Unisys U6000 svr4.0
To: [email protected]
Reply-To: [email protected]
Message-Id: <[email protected]>

Hi. I am attempting to port DBI/Oraperl, Perl5.001e to a Unisys U6000
running svr4.0 and Oracle V7, with mixed success. I just waant to check
that this is the correct forum for me to post my findings before doing
so.
Is it?

Alan Burlison [email protected]

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <01193-0@lion>;
Mon, 22 May 1995 23:09:16 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Mon, 22 May 95 21:59:40 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa10390;
22 May 95 22:59 +0100
Received: by gw.home.vix.com id AA29037; Mon, 22 May 95 10:08:51 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA29031; Mon, 22 May 95 10:08:49 -0700
Received: from centhub (centhub.mnet.uswest.com [151.116.23.137])
by uswat.advtech.uswest.com (8.6.12/8.6.12) with SMTP id LAA18702;
Mon, 22 May 1995 11:08:01 -0600
Original-Received: by centhub.mnet.uswest.com (M-Net
Hub.950111)
PP-warning: Illegal Received field on preceding line
Received: by coefmd3.uswest.com. (5.0/SMI-SVR4) id AA13954;
Mon, 22 May 1995 11:07:52 +0700
From: John Liptak <[email protected]>
Message-Id: <[email protected].>
Subject: Re: Announce: DBD-Oracle-0.15.tar.Z: Bind variables work!
To: Tim Bunce <[email protected]>
Date: Mon, 22 May 1995 11:07:51 -0600 (MDT)
Cc: [email protected]
In-Reply-To: <[email protected]> from "Tim Bunce" at May 20, 95 02:31:46 am
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 729

> Please, please, please, try this release and tell me about *anything*
> and *everything* you needed to do to get it to work on your platform
> with your compiler.

Solaris2.3
Oracle7.0.16.4
CenterLine2.10

I needed to modify the Makefile, changing:
COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/__fstd.o
to
COMPOBJS=$(COMPOBJ)/__fstd.o

perl core dumps on an illegal instruction in the dynamic load otherwise.

>
> Regards,
> Tim.
>

--
John Liptak - MTS U S WEST Communications
WK (303) 965-8853 1999 Broadway Room 1510
PG (303) 820-9284 Denver, Colorado 80202
[email protected] [email protected]

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <02691-10@lion>;
Tue, 23 May 1995 07:03:20 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 23 May 95 01:15:50 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa06418;
23 May 95 2:15 +0100
Received: by gw.home.vix.com id AA18236; Mon, 22 May 95 15:16:27 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA18232; Mon, 22 May 95 15:16:25 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa26665;
22 May 95 23:08 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id aa12984;
22 May 95 23:08 +0100
Received: from ig.co.uk by lion id <01183-0@lion>;
Mon, 22 May 1995 23:08:30 +0100
To: [email protected], [email protected]
Subject: Re: Porting DBI & Oraperl to Unisys U6000 svr4.0
Date: Mon, 22 May 1995 23:08:30 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: Alan Burlison <[email protected]>
>
> Hi. I am attempting to port DBI/Oraperl, Perl5.001e to a Unisys U6000
> running svr4.0 and Oracle V7, with mixed success. I just waant to check
> that this is the correct forum for me to post my findings before doing
> so.
> Is it?
>
It certainly is!

Make sure you're using the latest: DBD-Oracle-0.15.tar.Z.

Check the README for what information I'm likely to need from you.

If the posting is very big then it's okay to mail me direct and
I'll summarise to the list.

(I'll take this opportunity to remind people that I presume that
any email I get related to DBI/DBD's I can repost or follow up here
unless otherwise stated in the mail.)

> Alan Burlison [email protected]
>
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <02691-11@lion>;
Tue, 23 May 1995 07:03:27 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 23 May 95 01:44:51 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa11889;
23 May 95 2:43 +0100
Received: by gw.home.vix.com id AA22745; Mon, 22 May 95 16:25:23 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA22741; Mon, 22 May 95 16:25:22 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id am28841;
23 May 95 0:15 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id aa04822;
22 May 95 19:19 +0100
Received: from ig.co.uk by lion id <29749-0@lion>;
Mon, 22 May 1995 19:19:46 +0100
To: [email protected]
Subject: Re: Announce: DBD-Oracle-0.15.tar.Z: Bind variables work!
Cc: [email protected]
Date: Mon, 22 May 1995 19:19:46 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: John Liptak <[email protected]>
>
> > Please, please, please, try this release and tell me about *anything*
> > and *everything* you needed to do to get it to work on your platform
> > with your compiler.
>
> Solaris2.3
> Oracle7.0.16.4
> CenterLine2.10
>
> I needed to modify the Makefile, changing:
> COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/__fstd.o
> to
> COMPOBJS=$(COMPOBJ)/__fstd.o
>
> perl core dumps on an illegal instruction in the dynamic load otherwise.
>
Easy to fix but I'm trying to automate it.

Please send me (directly) the information requested in the README
(myconfig etc). Umm, maybe you should also throw in a copy of config.sh.

> John Liptak - MTS U S WEST Communications
> WK (303) 965-8853 1999 Broadway Room 1510
> PG (303) 820-9284 Denver, Colorado 80202
> [email protected] [email protected]
>
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <02691-12@lion>;
Tue, 23 May 1995 07:03:43 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Tue, 23 May 95 01:44:57 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa11968;
23 May 95 2:44 +0100
Received: by gw.home.vix.com id AA20224; Mon, 22 May 95 15:44:00 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA20218; Mon, 22 May 95 15:43:57 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa27041;
22 May 95 23:21 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id aa16629;
22 May 95 23:21 +0100
Received: from ig.co.uk by lion id <01380-0@lion>;
Mon, 22 May 1995 23:21:13 +0100
To: [email protected]
Subject: Re: Announce: DBD-Oracle-0.15.tar.Z: Bind variables work!
Cc: [email protected]
Date: Mon, 22 May 1995 23:21:13 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: John Liptak <[email protected]>
>
> > Please, please, please, try this release and tell me about *anything*
> > and *everything* you needed to do to get it to work on your platform
> > with your compiler.
>
> Solaris2.3
> Oracle7.0.16.4
> CenterLine2.10
>
> I needed to modify the Makefile, changing:
> COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/__fstd.o
> to
> COMPOBJS=$(COMPOBJ)/__fstd.o
>
> perl core dumps on an illegal instruction in the dynamic load otherwise.
>
Umm, I fixed it for GCC but ...

Could you send me (directly) a copy of the link command you get
during a build.

Does anyone else build on Solaris 2 using a NON-gcc compiler?

> John Liptak - MTS U S WEST Communications
> WK (303) 965-8853 1999 Broadway Room 1510
> PG (303) 820-9284 Denver, Colorado 80202
> [email protected] [email protected]
>
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <17836-18@lion>;
Wed, 24 May 1995 07:06:18 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 24 May 95 02:50:07 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa25757;
24 May 95 3:49 +0100
Received: by gw.home.vix.com id AA09015; Tue, 23 May 95 16:13:00 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA09008; Tue, 23 May 95 16:12:57 -0700
Received: by srs.gov id AA11140 (InterLock SMTP Gateway 1.1
for [email protected]); Tue, 23 May 1995 19:11:30 -0400
Received: by srs.gov (Internal Mail Agent-2); Tue, 23 May 1995 19:11:30 -0400
Received: by srs.gov (Internal Mail Agent-1); Tue, 23 May 1995 19:11:30 -0400
Date: Tue, 23 May 1995 19:11:11 -0400
From: James Taylor <[email protected]>
Subject: Re: Announce: DBD-Oracle-0.15.tar.Z: Bind variables work!
In-Reply-To: <[email protected]>
To: David Moellenhoff/MSI <[email protected]>
Cc: Tim Bunce <[email protected]>, perldb-interest <[email protected]>
Reply-To: James Taylor <[email protected]>
Message-Id: <[email protected]>
X-Envelope-To: David_Moellenhoff%[email protected],
perldb-interest%[email protected],
Tim.Bunce%[email protected]
Content-Transfer-Encoding: 7BIT
X-Attribution: james.taylor
References: <[email protected]>

>>> MSI writes:
M> Attempting to compile DBD-Oracle-0.15 with Solaris 2.3, gcc and
M> Oracle 7.1.3 yields the following fun:

M> ----- Script started on Tue May 23 12:02:13 1995 davem@pebble
M> ~/perl/Oracle> perl Makefile.PL

M> Configuring DBD::Oracle version 0.15... Using Oracle in
M> /usr/oracle/product/7.1.3 Error parsing
M> /usr/oracle/product/7.1.3/proc/lib/proc.mk (version '1.11'):
M> OCILDLIBS not found Using oracle.mk version 1.11 Oracle
M> sysliblist: -lsocket -lnsl -lm -ldl -laio Use of uninitialized
M> value at Makefile.PL line 63. System: perl5.001 sunos pebble 5.3
M> generic_101318-59 sun4m sparc gcc -O3 -DUNEXEC

M> Writing Makefile for DBD::Oracle davem@pebble ~/perl/Oracle> make

M> make: Fatal error in reader: Makefile, line 507: :/:: conflict
M> for target `all'

I had the same problem, but have not had time to explore beyond the
line 507 error.

Oracle 7.1.4, Solaris 2.4, Sun's CC.

James Taylor

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <17834-17@lion>;
Wed, 24 May 1995 07:06:06 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 24 May 95 01:34:06 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa14972;
24 May 95 2:33 +0100
Received: by gw.home.vix.com id AA24568; Tue, 23 May 95 12:26:02 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA24564; Tue, 23 May 95 12:26:01 -0700
Received: from msi-gateway1.metropolis.com
by gaia.internex.net (SMI-8.6.9/SMI-SVR4) id MAA00044;
Tue, 23 May 1995 12:25:58 -0700
Received: by msi-gateway1.metropolis.com (IBM OS/2 SENDMAIL VERSION 1.3.2)/1.1)
id AA2425; Tue, 23 May 95 12:31:09 -0700
Message-Id: <[email protected]>
Received: from MSI Notes Network with "Lotus Notes Mail Gateway for SMTP"
id 8CF43B5B4ADB3FC0882561C50068C6BE; Tue, 23 May 95 12:31:00
To: Tim Bunce <[email protected]>
Cc: perldb-interest <[email protected]>
From: David Moellenhoff/MSI <[email protected]>
Date: 23 May 95 12:24:41 EDT
Subject: Re: Announce: DBD-Oracle-0.15.tar.Z: Bind variables work!
Mime-Version: 1.0
Content-Type: Text/Plain

Attempting to compile DBD-Oracle-0.15 with Solaris 2.3, gcc and
Oracle 7.1.3 yields the following fun:

-----
Script started on Tue May 23 12:02:13 1995
davem@pebble ~/perl/Oracle> perl Makefile.PL

Configuring DBD::Oracle version 0.15...
Using Oracle in /usr/oracle/product/7.1.3
Error parsing /usr/oracle/product/7.1.3/proc/lib/proc.mk (version '1.11'):
OCILDLIBS not found
Using oracle.mk version 1.11
Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio
Use of uninitialized value at Makefile.PL line 63.
System: perl5.001 sunos pebble 5.3 generic_101318-59 sun4m sparc gcc -O3
-DUNEXEC

Writing Makefile for DBD::Oracle
davem@pebble ~/perl/Oracle> make

make: Fatal error in reader: Makefile, line 507: :/:: conflict for target `all'

script done on Tue May 23 12:02:40 1995
-----

Editing out the conflicting targets (all,clean,install) will allow the DBD to
build,
but leads to the following:

-----
Script started on Tue May 23 12:10:18 1995
davem@pebble ~/perl/Oracle> make all

mkdir /export/home/davem/perl/Oracle/blib
mkdir /export/home/davem/perl/Oracle/blib/DBD
mkdir /export/home/davem/perl/Oracle/blib/auto
mkdir /export/home/davem/perl/Oracle/blib/auto/DBD
mkdir /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle
/usr/local/bin/perl /usr/local/lib/perl5/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc
Oracle.c
gcc -c -DUNEXEC -O3 -fpic -I/usr/local/lib/perl5/sun4-solaris/CORE -Wall
-Wno-comment -Wpointer-arith -Wcast-align -Wconversion
-I/usr/oracle/product/7.1.3/rdbms/demo -I/usr/local/lib/perl5/sun4-solaris/DBI
Oracle.c
Oracle.c: In function `do_error':
Oracle.c:132: warning: passing arg 2 of `oerhms' with different width due to
prototype
Oracle.c: In function `sth_ph_bind':
Oracle.c:277: warning: passing arg 5 of `obndrv' as signed due to prototype
Oracle.c:277: warning: passing arg 9 of `obndrv' makes pointer from integer
without a cast
Oracle.c: In function `XS_DBD__Oracle__db_oparse':
Oracle.c:478: warning: long int format, int arg (arg 4)
Oracle.c: In function `XS_DBD__Oracle__db_FETCH':
Oracle.c:584: warning: unused variable `imp_dbh'
Oracle.c: In function `XS_DBD__Oracle__st_STORE':
Oracle.c:785: warning: unused variable `dbh'
Running mkbootstrap for DBD::Oracle ()
ld -o /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.so -G Oracle.o
-L/usr/oracle/product/7.1.3/lib /usr/oracle/product/7.1.3/lib/__fstd.o
-lsocket -lnsl -lm -ldl -laio
cp Oracle.bs /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.bs
cp Oraperl.pm /export/home/davem/perl/Oracle/blib/Oraperl.pm
cp Oracle.pm /export/home/davem/perl/Oracle/blib/DBD/Oracle.pm
davem@pebble ~/perl/Oracle> make test

/usr/local/bin/perl -I/export/home/davem/perl/Oracle/blib
-I/export/home/davem/perl/Oracle/blib -I/usr/local/lib/perl5/sun4-solaris
-I/usr/local/lib/perl5 -e 'use Test::Harness qw(&runtests $verbose);
$verbose=0; runtests @ARGV;' t/*.t
t/base..............ok
t/main..............ok
All tests successful.
Files=2, Tests=6, 1 secs ( 0.82 cusr 0.32 csys = 1.14 cpu)
/usr/local/bin/perl -I/export/home/davem/perl/Oracle/blib
-I/export/home/davem/perl/Oracle/blib -I/usr/local/lib/perl5/sun4-solaris
-I/usr/local/lib/perl5 test.pl
Identifier "main::opt_d" used only once: possible typo at test.pl line 27.
Oraperl test application $Revision: 1.8 $
DBD::Oracle driver installed as DBI::dr=HASH(0x13f72c)
DBI::dr=HASH(0x14de3c) debug level set to 1

Oraperl Emulation Interface $Revision: 1.12 $
Oracle Driver $Revision: 1.12 $
DBI Switch by Tim Bunce, $Revision: 1.31 $

ld.so.1: /usr/local/bin/perl: fatal: relocation error: symbol not found: orlon:
referenced in /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.so
*** Signal 9
make: Fatal error: Command failed for target `test'
davem@pebble ~/perl/Oracle> exit
script done on Tue May 23 12:10:45 1995
-----

Here's my proc.mk:

#
# $Header: proc.mk.pp 1.11 94/05/25 17:37:29 jpau Osd<unix> $ proc.mk.pp
#
#
# proc.mk - Command file for "make" to compile and load Pro*C 2.0 programs.
#
# Usage to build any program:
# make -f proc.mk EXE=xyz OBJS="a.o b.o c.o"
#
# Special syntax to link demo program:
# make -f proc.mk sample1
#
# Special syntax to link and install proc executable:
# make -f proc.mk install
#
# NOTE: ORACLE_HOME must be either:
# . set in the user's environment
# . passed in on the command line
# . defined in a modified version of this makefile
#
# Pro*C programs are assumed to have the extension ".pc"
#

SHELL=/bin/sh

LIBHOME=$(ORACLE_HOME)/lib

I_SYM= -I

CC=cc

CFLAGS=
COMPOBJ=$(ORACLE_HOME)/lib
COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/__fstd.o
LDSTRING= -Y P,$(LD_LIBRARY_PATH):/usr/ccs/lib:/usr/lib -Qy -lc
$(COMPOBJ)/crtn.o
CC= ld -dy $(COMPOBJS) $(LDSTRING)
ASFLAGS=-P
RCC=cc -I. -O -xcg92

CFLAGS=
COMPOBJ=$(ORACLE_HOME)/lib
COMPOBJS=$(COMPOBJ)/crti.o $(COMPOBJ)/crt1.o $(COMPOBJ)/__fstd.o
LDSTRING= -Y P,$(LD_LIBRARY_PATH):/usr/ccs/lib:/usr/lib -Qy -lc
$(COMPOBJ)/crtn.o
CC= ld -dy $(COMPOBJS) $(LDSTRING)
ASFLAGS=-P
RCC=cc -I. -O -xcg92

CFLAGS=

LDFLAGS=-L$(LIBHOME)

ARLOCAL=

AR=ar $(ARLOCAL)
ARCREATE=ar cr$(ARLOCAL)
ARDELETE=ar d$(ARLOCAL)
ARREPLACE=ar r$(ARLOCAL)

ECHO=$(ORACLE_HOME)/bin/echodo

OTHERLIBS=`cat $(ORACLE_HOME)/rdbms/lib/sysliblist` $(MLSLIBS)

LLIBPSO=
LLIBPSO=-lstublm

XLIBHOME = /usr/lib
MOTIFLIBHOME = /usr/lib
MOTIFLIBS = -L$(MOTIFLIBHOME) -lXm -L$(XLIBHOME) -lXt -lX11 -lm

MOTIFLIBS = -L$(MOTIFLIBHOME) -lXm -lgen -L$(XLIBHOME) -lXt -lX11 -lw -lm

CLIBS=$(OTHERLIBS)

SO=a

NLSRTLHOME= $(SRCHOME)/nlsrtl23

NLSRTLLIB= -lnlsrtl
LIBNLSRTL= $(LIBHOME)/libnlsrtl.a
LLIBNLSRTL=-lnlsrtl

NLSRTLINC= $(I_SYM)$(NLSRTLHOME)/oracore/public
NLSRTLPUBLIC= $(I_SYM)$(NLSRTLHOME)/public $(STDINCLUDE)

COREHOME= $(SRCHOME)/oracore

LIBCORE= $(LIBHOME)/libcore.$(SO)
LIBCV6= $(LIBHOME)/libcv6.$(SO)
LLIBCORE= -lcore
LLIBCV6= -lcv6

CORELIBD= $(LIBNLSRTL) $(LIBCV6) $(LIBCORE)
CORELIBS= $(LLIBNLSRTL) $(LLIBCV6) $(LLIBCORE) $(LLIBNLSRTL)
$(LLIBCV6) $(LLIBCORE)

LIBNETWORK= $(LIBHOME)/libnetwork.a
NTCONTAB= $(LIBHOME)/ntcontab.o

TNSLIBS= -lnetwork
TNSLIBD= $(LIBNETWORK)

LIBNETV2= $(LIBHOME)/libnetv2.a
NETV2LIBS= -lnetv2 $(TNSLIBS)
NETV2LIBD= $(LIBNETV2) $(TNSLIBD)

LIBNSG= $(LIBHOME)/libnsg.a
LLIBNSG= -lnsg
NSGLIBS= $(LLIBNSG)
NSGLIBD= $(LIBNSG)

OSNTAB= $(LIBHOME)/osntab.o
OSNTABST= $(LIBHOME)/osntabst.o
LIBSQLNET= $(LIBHOME)/libsqlnet.a
SQLNETLIBS= -lsqlnet

NETLIBS= $(OSNTAB) $(SQLNETLIBS) $(NETV2LIBS)
NETLIBD= $(OSNTAB) $(LIBSQLNET) $(NETV2LIBD)

LIBPLS= $(LIBHOME)/libpls.a
LLIBPLS= -lpls

LIBTK2C= $(LIBHOME)/libtk2c.a
LLIBTK2C= -ltk2c
LIBTK2M= $(LIBHOME)/libtk2m.a
LLIBTK2M= -ltk2m
LIBTK2P= $(LIBHOME)/libtk2p.a
LLIBTK2P= -ltk2p
LIBTK2UC= $(LIBHOME)/libuc.a
LLIBTK2UC= -luc
LIBTK2REM= $(LIBHOME)/librem.a
LLIBTK2REM= -lrem
LIBTK2ROS= $(LIBHOME)/libros.a
LLIBTK2ROS= -lros
LIBTK2OT= $(LIBHOME)/libot.a
LLIBTK2OT= -lot
LIBTK2OTX= $(LIBHOME)/libotx.a
LLIBTK2OTX= -lotx
LIBTK2UT= $(LIBHOME)/libut.a
LLIBTK2UT= -lut
LIBTK2SL= $(LIBHOME)/libsl.a
LLIBTK2SL= -lsl
LIBTK2RE= $(LIBHOME)/libre.a
LLIBTK2RE= -lre

TK2UICLIBD= $(LIBTK2RE) $(LIBTK2UC) $(LIBTK2C) $(LIBTK2OT) $(LIBTK2REM)
$(LIBTK2ROS) $(LIBTK2P) $(LIBTK2UT) $(LIBTK2SL)

TK2UICLIBS= $(DYNAMIC_ON_TK2) $(LLIBTK2SL) $(LLIBTK2RE) $(LLIBTK2UC)
$(LLIBTK2C) $(LLIBTK2OT) $(LLIBTK2RE) $(LLIBTK2REM) $(LLIBTK2ROS) $(LLIBTK2C)
$(LLIBTK2P) $(LLIBTK2C) $(LLIBTK2P) -lm $(LLIBTK2REM) $(LLIBTK2C)
$(LLIBTK2OT) $(LLIBTK2UT) $(LLIBTK2UC) $(LLIBTK2SL) $(LLIBTK2C)
$(DYNAMIC_OFF_TK2)

TK2UIMLIBD= $(LIBTK2OT) $(LIBTK2RE) $(LIBTK2UC) $(LIBTK2REM) $(LIBTK2ROS)
$(LIBTK2M) $(LIBTK2P) $(LIBTK2UT) $(LIBTK2SL)

TK2UIMLIBS= $(DYNAMIC_ON_TK2) $(LLIBTK2OT) $(LLIBTK2RE) $(LLIBTK2UC)
$(LLIBTK2REM) $(LLIBTK2ROS) $(LLIBTK2M) $(LLIBTK2P) $(LLIBTK2M) $(LLIBTK2P)
$(LLIBTK2M) $(LLIBTK2OT) $(LLIBTK2UT) $(LLIBTK2SL) $(DYNAMIC_OFF_TK2)

AIXSTLIBOPT=

LIBOCIC= $(LIBHOME)/libocic.a
LLIBOCIC= -locic

TTLIBD= $(NETLIBD) $(LIBORA) $(CORELIBD)
TTLIBS= $(OSNTAB) $(SQLNETLIBS) $(LLIBORA) $(LIBPLSHACK) $(SQLNETLIBS)
$(LLIBORA) $(CORELIBS) $(LDLIBS) $(CLIBS)

STLIBDNOPLS= $(OSNTABST) $(CONFIG) $(CORELIBD) $(NETLIBD) $(RDBMSLIBDNOPLS)
STLIBD= $(OSNTABST) $(CONFIG) $(CORELIBD) $(NETLIBD) $(RDBMSLIBD)
STLIBSNOPLS= $(OSNTABST) $(CONFIG) $(RDBMSLIBSNOPLS) $(RDBMSLIBSNOPLS)
$(AIXSTLIBOPT) $(SQLNETLIBS) $(LLIBORA) $(CORELIBS) $(LLIBPSO) $(LDLIBS)
$(CLIBS)
STLIBS= $(OSNTABST) $(CONFIG) $(RDBMSLIBS) $(RDBMSLIBS) $(AIXSTLIBOPT)
$(SQLNETLIBS) $(LLIBORA) $(CORELIBS) $(LLIBPSO) $(LDLIBS) $(CLIBS)

LLIBNETV2= $(LIBNETV2)
LLIBNETWORK= $(LIBNETWORK)

CONFIG= $(LIBHOME)/config.o
OPIMAI= $(LIBHOME)/opimai.o
LIBORA= $(LIBHOME)/libora.a
LIBKNL= $(LIBHOME)/libknl.a
LIBKNLOPT= $(LIBHOME)/libknlopt.a
LLIBORA= -lora
LLIBKNL= -lknl
LLIBKNLOPT= -lknlopt

RDBMSLIBDNOPLS= $(LIBORA) $(LIBKNLOPT) $(LIBKNL)
RDBMSLIBD= $(LIBORA) $(LIBKNLOPT) $(LIBPLS) $(LIBKNL)
RDBMSLIBSNOPLS= $(LLIBORA) $(LLIBKNLOPT) $(LLIBKNL)
RDBMSLIBS= $(LLIBORA) $(LLIBKNLOPT) $(LLIBPLS) $(LLIBKNL)

LIBSOSD=
LLIBSOSD=

LIBPCORE=$(LIBHOME)/libpcore.a
LLIBPCORE= -lpcore

LIBCGEN= $(LIBHOME)/pdc.o
LIBFORGEN= $(LIBHOME)/pdf.o
LIBCOBGEN= $(LIBHOME)/pdb.o
LIBPASGEN=
LIBADAGEN= $(LIBHOME)/pda.o
LIBOSDGEN= $(LIBHOME)/pds.o

CODEGENHOME= $(SRCHOME)/codegen

LIBSLAX=$(LIBHOME)/pxslax.o

SQLPUBLIC=$(I_SYM)$(SQLHOME)/public
LIBSQL= $(LIBHOME)/libsql.a
SQLLIBS= -lsql

LIBPROC20=$(LIBHOME)/libproc.a
LLIBPROC20= -lproc
LIBPRO= $(LIBPROC20)
LLIBPRO= $(LLIBPROC20)
PROLDLIBS= $(SQLLIBS) $(TTLIBS)
PROCINCS=include=$(ORACLE_HOME)/oracore/public
include=$(ORACLE_HOME)/sqllib/public include=$(ORACLE_HOME)/rdbms/public
include=$(ORACLE_HOME)/nlsrtl23/public

PROC=$(ORACLE_HOME)/bin/proc

CFLAGS=

PROCINC=$(I_SYM)$(ORACLE_HOME)/proc/lib
PROCOBJS=$(ORACLE_HOME)/proc/lib/main.o \
$(ORACLE_HOME)/proc/lib/pcdsfv.o \
$(ORACLE_HOME)/proc/lib/pcdlut.o
PROCPLSFLAGS= sqlcheck=full userid=$(USERID) dbms=v6_char
USERID= scott/tiger
EXE= sample1
OBJS= sample1.o
SAMPLES=sample1 sample2 sample3 sample4 sample6 sample7 sample8 sample9
sample10 sqlvcp

all: build

# Rule to compile any program (specify EXE= and OBJS= on command line)
build: $(OBJS)
$(RCC) $(CFLAGS) $(LDFLAGS) -o $(EXE) $(OBJS) $(PROLDLIBS)

# "Shorthand" Rule to compile all the sample program
samples: $(SAMPLES)

$(SAMPLES):
$(MAKE) -f $(ORACLE_HOME)/proc/lib/proc.mk [email protected] EXE=$@ build

#
# Before compiling sample9 program, you must run calldemo.sql script
# as scott/tiger.
#

sample9.o: sample9.pc
$(PROC) $(PROCPLSFLAGS) iname=$*.pc
$(RCC) $(CFLAGS) $(PROCINC) -c $*.c

# Suffix rules
SUFFIXES: .exe .o .c .pc

pc.c:
$(PROC) $(PROFLAGS) iname=$*.pc

pc.o:
$(PROC) $(PROFLAGS) iname=$*.pc
$(RCC) $(CFLAGS) $(PROCINC) -c $*.c

c.o:
$(RCC) $(CFLAGS) $(PROCINC) -c $*.c

LIBDIR= $(ORACLE_HOME)/proc/lib
DEMODIR= $(ORACLE_HOME)/proc/demo

install_files:
-rm -f $(LIBDIR)/ORACA.H
-rm -f $(LIBDIR)/SQLCA.H
-rm -f $(LIBDIR)/SQLDA.H
-rm -f $(DEMODIR)/proc.mk
-ln $(LIBDIR)/oraca.h $(LIBDIR)/ORACA.H
-ln $(LIBDIR)/sqlca.h $(LIBDIR)/SQLCA.H
-ln $(LIBDIR)/sqlda.h $(LIBDIR)/SQLDA.H
-ln $(LIBDIR)/proc.mk $(DEMODIR)/proc.mk

# Rules to relink the proc executable
install: clean proc
-chmod 755 $(ORACLE_HOME)/bin/proc
-mv proc $(ORACLE_HOME)/bin/proc
-chmod 755 $(ORACLE_HOME)/bin/proc

clean:
-rm -f proc

proc:
@$(ECHO) $(CC) $(LDFLAGS) -o proc $(PROCOBJS) \
$(LLIBPROC20) $(LIBCGEN) $(LLIBPLS) $(LIBOSDGEN) $(LIBSLAX) \
$(LLIBPCORE) $(LLIBPLS) $(LLIBORA) $(LLIBPLS) $(TTLIBS) -lm

#
# Sample Pro*C user-exits.
#
LIBFORMS30C=$(LIBHOME)/libforms30c.a
LIBFORMS30=$(LIBHOME)/libforms30.a
LIBFORMS30P=$(LIBHOME)/libforms30p.a
LIBOKT=$(LIBHOME)/libokt.a
LIBOKTC=$(LIBHOME)/liboktc.a

UXTLDLIBS= $(ORACLE_HOME)/forms30/lib/iaddrvc.o \
$(ORACLE_HOME)/forms30/lib/ifmdmf.o \
$(ORACLE_HOME)/forms30/lib/ifplut.o \
$(LIBFORMS30C) $(LIBFORMS30) $(LIBFORMS30P) $(LIBOKTC) $(LIBOKT) \
$(ORACLE_HOME)/forms30/lib/libpls.a $(LIBFORMS30C) $(LIBFORMS30) \
$(LIBOCIC) $(LIBSQL) $(TTLIBS)

sample5: sample5.pc
$(PROC) iname=sample5.pc $(PROFLAGS)
@$(ECHO) $(RCC) $(PROCINC) $(CFLAGS) $(LDFLAGS) -o sample5 sample5.c \
$(UXTLDLIBS)

-----

Obviously, it's not finding the OCI libraries. Any thoughts?

-Dave

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <24056-9@lion>;
Wed, 24 May 1995 17:23:53 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 24 May 95 15:01:56 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa19320;
24 May 95 16:01 +0100
Received: by gw.home.vix.com id AA03205; Tue, 23 May 95 23:36:12 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA03153; Tue, 23 May 95 23:31:54 -0700
Received: by ki1.chemie.fu-berlin.de (Smail3.1.28.1)
from uriela.in-berlin.de (192.109.42.147) with smtp
id <m0sE9wH-0000ZIC>; Wed, 24 May 95 08:29 MEST
Received: by uriela.in-berlin.de (/\oo/\ Smail3.1.29.1 #29.8)
id <[email protected]>;
Wed, 24 May 95 08:29 MET DST
Received: by uriela.in-berlin.de (Smail3.1.29.1 #8) id m0sE9vM-000BbUC;
Wed, 24 May 95 08:28 MET DST
Message-Id: <[email protected]>
Date: Wed, 24 May 95 08:28 MET DST
From: Anderas Koenig <[email protected]>
To: [email protected]
Subject: Writing a DBD::XXX
Reply-To: [email protected]

I think the time is ripe to write a DBD::Msql. What do you think? Has
anybody else used DBI for a DBD::* module?

I'm not fond to try this, if you, Tim, say DBI is not yet stable
enough. OTOH I'm tired of doing all the cgi stuff on the basis of my
current Msql implementation.

The simple question is
- should I do it now, and if
- how to?

Given that there is no 'commit' in msql, how should execute/commit be used?

Regards,
andreas

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <26925-7@lion>;
Thu, 25 May 1995 07:02:36 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 24 May 95 19:21:20 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa15356;
24 May 95 20:21 +0100
Received: by gw.home.vix.com id AA23326; Wed, 24 May 95 04:53:49 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA23322; Wed, 24 May 95 04:53:47 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa04142;
24 May 95 12:49 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id ac26463;
24 May 95 12:49 +0100
Received: from ig.co.uk by lion id <20756-0@lion>;
Wed, 24 May 1995 10:43:14 +0100
To: [email protected]
Subject: Re: Announce: DBD-Oracle-0.15.tar.Z: Bind variables work!
Date: Wed, 24 May 1995 10:43:14 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

If you see this message:

/usr/oracle/product/7.1.3/proc/lib/proc.mk (version '1.11'):
OCILDLIBS not found Using oracle.mk version 1.11 Oracle

Then don't bother digging deeper. I had simply forgotten to test
Makefile.PL against all those proc.mk files you kindly sent me.

I'll try to make a new release today.

Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <26923-20@lion>;
Thu, 25 May 1995 07:05:48 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 24 May 95 23:02:05 GMT
Received: from gw.home.vix.com by post.demon.co.uk id ab20434;
25 May 95 0:01 +0100
Received: by gw.home.vix.com id AA08282; Wed, 24 May 95 09:12:58 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA08278; Wed, 24 May 95 09:12:56 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa16962;
24 May 95 17:11 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id aa18971;
24 May 95 17:11 +0100
Received: from ig.co.uk by lion id <23480-0@lion>;
Wed, 24 May 1995 15:38:59 +0100
To: [email protected]
Subject: DBD::Oracle update
Date: Wed, 24 May 1995 15:38:59 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

I've fixed most the the problems and made things more robust.

Sadly I won't have time to complete this today.

I hope to release a new version (along with a minor DBI update)
tomorrow.

Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <26925-22@lion>;
Thu, 25 May 1995 07:06:39 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 25 May 95 03:26:31 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa27582;
25 May 95 4:26 +0100
Received: by gw.home.vix.com id AA07791; Wed, 24 May 95 16:40:54 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA07780; Wed, 24 May 95 16:40:50 -0700
Received: from zyzzyva.com ([email protected] [127.0.0.1])
by sierra.zyzzyva.com (8.6.11/8.6.11) with ESMTP id SAA03340;
Wed, 24 May 1995 18:36:04 -0500
Message-Id: <[email protected]>
To: [email protected]
Subject: Re: Writing a DBD::XXX
Cc: [email protected]
In-Reply-To: k's message of Wed, 24 May 1995 08:28:00 +0700. <[email protected]>
X-Uri: http://www.zyzzyva.com/
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Wed, 24 May 1995 18:34:24 -0500
From: Randy Terbush <[email protected]>

> I think the time is ripe to write a DBD::Msql. What do you think? Has
> anybody else used DBI for a DBD::* module?
>
> I'm not fond to try this, if you, Tim, say DBI is not yet stable
> enough. OTOH I'm tired of doing all the cgi stuff on the basis of my
> current Msql implementation.
>
> The simple question is
> - should I do it now, and if
> - how to?
>
> Given that there is no 'commit' in msql, how should execute/commit be used?
>

I am interested in doing the same for Postgres95.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <28218-3@lion>;
Thu, 25 May 1995 07:07:15 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 25 May 95 05:59:05 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa25811;
25 May 95 6:58 +0100
Received: by gw.home.vix.com id AA17867; Wed, 24 May 95 19:35:29 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA17863; Wed, 24 May 95 19:35:28 -0700
X400-Received: by mta bnr.ca in /PRMD=BNR/ADMD=TELECOM.CANADA/C=CA/; Relayed;
Wed, 24 May 1995 22:35:06 -0400
X400-Received: by /PRMD=BNR/ADMD=TELECOM.CANADA/C=CA/; Relayed;
Wed, 24 May 1995 22:34:19 -0400
X400-Received: by /PRMD=BNR/ADMD=TELECOM.CANADA/C=CA/; Relayed;
Mon, 22 May 1995 22:34:00 -0400
Date: Wed, 24 May 1995 22:34:00 -0400
X400-Originator: /dd.id=0146423/g=daniel/i=dg/s=cayouette/@bnr.ca
X400-Mts-Identifier: [/PRMD=BNR/ADMD=TELECOM.CANADA/C=CA/;bcars735.b.438:25.04.95.02.34.19]
X400-Content-Type: P2-1984 (2)
Content-Identifier: fw:Re: Writin...
From: "daniel (d.g.) cayouette" <[email protected]>
Sender: "daniel (d.g.) cayouette" <[email protected]>
Message-Id: <"28460 Wed May 24 22:34:54 1995"@bnr.ca>
To: [email protected]
Subject: fw:Re: Writing a DBD::XXX
X-Attachments: "ORIGINAL.HEADER" (type: text)

What does writing a DBD::XXX entail? Are msql and Postgres95 other
perl db extensions like oraperl?

I know that there other perl db extensions out there. How would these
be folded in to DBD::XXX if they have a different syntax. Would this
actually make any sense?

Daniel

---forwarded message---->

From: '[email protected]' (BNR400)

Subject: Re: Writing a DBD::XXX

Sent by: '[email protected]' (BNR400)

> I think the time is ripe to write a DBD::Msql. What do you think? Has
> anybody else used DBI for a DBD::* module?
>
> I'm not fond to try this, if you, Tim, say DBI is not yet stable
> enough. OTOH I'm tired of doing all the cgi stuff on the basis of my
> current Msql implementation.
>
> The simple question is
> - should I do it now, and if
> - how to?
>
> Given that there is no 'commit' in msql, how should execute/commit be used?
>

I am interested in doing the same for Postgres95.

Received: from gw.home.vix.com by bnr.ca id <[email protected]>; Wed, 24 May 1995 20:42:11 -0400
Received: by gw.home.vix.com id AA07791; Wed, 24 May 95 16:40:54 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA07780; Wed, 24 May 95 16:40:50 -0700
Received: from zyzzyva.com ([email protected] [127.0.0.1]) by sierra.zyzzyva.com (8.6.11/8.6.11) with ESMTP id SAA03340; Wed, 24 May 1995 18:36:04 -0500
Message-Id: <[email protected]>
To: [email protected]
Subject: Re: Writing a DBD::XXX
Cc: [email protected]
In-Reply-To: k's message of Wed, 24 May 1995 08:28:00 +0700.
<[email protected]>
X-Uri: http://www.zyzzyva.com/
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Wed, 24 May 1995 18:34:24 -0500
From: Randy Terbush <[email protected]>

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <03958-1@lion>;
Thu, 25 May 1995 12:57:49 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Thu, 25 May 95 08:01:20 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa05874;
25 May 95 9:00 +0100
Received: by gw.home.vix.com id AA27588; Wed, 24 May 95 22:28:31 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA27584; Wed, 24 May 95 22:28:30 -0700
Received: by ki1.chemie.fu-berlin.de (Smail3.1.28.1)
from uriela.in-berlin.de (192.109.42.147) with smtp
id <m0sEVSo-0000XbC>; Thu, 25 May 95 07:28 MEST
Received: by uriela.in-berlin.de (/\oo/\ Smail3.1.29.1 #29.8)
id <[email protected]>;
Thu, 25 May 95 07:27 MET DST
Received: by uriela.in-berlin.de (Smail3.1.29.1 #8) id m0sEVRr-000BbUC;
Thu, 25 May 95 07:27 MET DST
Message-Id: <[email protected]>
Date: Thu, 25 May 95 07:27 MET DST
From: Andreas Koenig <[email protected]>
To: [email protected]
Cc: [email protected]
In-Reply-To: <"28460 Wed May 24 22:34:54 1995"@bnr.ca> ([email protected])
Subject: Re: fw:Re: Writing a DBD::XXX
Reply-To: [email protected]

> What does writing a DBD::XXX entail? Are msql and Postgres95 other
>perl db extensions like oraperl?
>
> I know that there other perl db extensions out there. How would these
>be folded in to DBD::XXX if they have a different syntax. Would this
>actually make any sense?

Err, that's the reason why Tim is inventing DBI -- so they all get a
common interface.

andreas

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <19447-6@lion>;
Fri, 26 May 1995 07:01:58 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Fri, 26 May 95 00:05:48 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa03305;
26 May 95 1:04 +0100
Received: by gw.home.vix.com id AA18681; Thu, 25 May 95 12:27:15 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA18677; Thu, 25 May 95 12:27:14 -0700
Received: by condor.messaging.cs.mci.com; id AA31757;
Thu, 25 May 1995 13:24:48 -0600
Date: Thu, 25 May 1995 13:24:48 -0600
Message-Id: <[email protected]>
X-Sender: [email protected]
X-Mailer: Windows Eudora Version 2.1
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
To: Tim Bunce <[email protected]>, [email protected]
From: Patrick Crawford <[email protected]>
Subject: DBM problem in perl5.001e?

Tim,

Saw you responding to some dbm question on comp.lang.perl, but our server
wiped out the actual text of the message. Mebbe you know what is going on here:

Under perl4.036 I wrote a data collector daemon which stuffed the results
into a dbm. It keeps the dbm open all the time, and does a reset everytime
it has new data.

Another perl4 program, which uses curseperl4.035, opens the dbm
periodically, and displays the results. This works great.

However,

I am attempting to port both scripts to perl5. What happens is:

The data collector daemon runs under perl5 just as it did under perl4,
though it creates a dbm incompatible with perl4.

The problem is that the script that does the display, which I am converting
to Tk, tries to dbmopen the database, and the open fails. It uses exactly
the same dbmopen code as the old curseperl script.

Can help?

Pat

--
Patrick Crawford, Software Engineer MCI Information Systems Corporation
Phone: +1 719-535-4255 Messaging Development 1819/117
Fax: +1 719-535-4678 2424 Garden of the Gods Road
[email protected] Colorado Springs, CO 80919

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <19508-7@lion>;
Fri, 26 May 1995 07:03:28 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Fri, 26 May 95 02:50:14 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa07612;
26 May 95 3:49 +0100
Received: by gw.home.vix.com id AA29066; Thu, 25 May 95 15:29:34 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA29062; Thu, 25 May 95 15:29:32 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa10362;
25 May 95 22:51 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id ab08076;
25 May 95 22:51 +0100
Received: from ig.co.uk by lion id <17940-0@lion>;
Thu, 25 May 1995 22:46:53 +0100
To: [email protected]
Subject: Announce: DBI-0.55.tar.Z and DBD-Oracle-0.16.tar.Z
Date: Thu, 25 May 1995 22:46:53 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

You'll need to get both modules.

DBI changes:

Exporter removed (wasn't used anyway)

Minor debugging enhancements.

Relationship between disconnect, _untie and DESTROY improved.

Fixed some compiler warnings.

DBD::Oracle Major changes:

Makefile.PL more robust and flexible.

Code restructured - much more still to do.

Changes to ora_do. It's probably still not right.

This is a fairly major code revision, expect teething problems.

Please, please, please, try this release and tell me about *anything*
and *everything* you needed to do to get it to work on your platform
with your compiler. Also send me a copy of any compiler warnings you
get.

Hopefully the enhanced Makefile.PL will mean a smooth build on most
platforms. Joel, you're going to have to send me more details about
your SCO Oracle. I don't have enough to hand to find a good fix for you.

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <20541-9@lion>;
Wed, 31 May 1995 07:06:13 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 31 May 95 00:33:37 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa25349;
31 May 95 1:33 +0100
Received: by gw.home.vix.com id AA04592; Tue, 30 May 95 12:49:51 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA04588; Tue, 30 May 95 12:49:48 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa13522;
30 May 95 20:49 +0100
Received: from [158.152.8.99] by post.demon.co.uk id aa12674;
30 May 95 20:49 +0100
Received: from ig.co.uk by lion id <16205-0@lion>;
Tue, 30 May 1995 20:37:33 +0100
To: [email protected]
Subject: Re: Writing a DBD::XXX
Date: Tue, 30 May 1995 20:37:33 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

I'm glad this is come up now.

> From: Anderas Koenig <[email protected]>
>
> I think the time is ripe to write a DBD::Msql. What do you think? Has
> anybody else used DBI for a DBD::* module?
>
The time is certainly ripe for talking about it.

> I'm not fond to try this, if you, Tim, say DBI is not yet stable
> enough. OTOH I'm tired of doing all the cgi stuff on the basis of my
> current Msql implementation.
>
> The simple question is
> - should I do it now, and if
> - how to?
>
> Given that there is no 'commit' in msql, how should execute/commit be used?
>
Read the DBperl spec! (Sorry, couldn't resist ;-)

> From: Randy Terbush <[email protected]>
>
> I am interested in doing the same for Postgres95.
>
That would be great.

> From: "daniel (d.g.) cayouette" <[email protected]>
>
> What does writing a DBD::XXX entail? Are msql and Postgres95 other
> perl db extensions like oraperl?
>
> I know that there other perl db extensions out there. How would these
> be folded in to DBD::XXX if they have a different syntax. Would this
> actually make any sense?
>
Read the DBperl spec! (Sorry, couldn't resist, again ;-)

> Daniel
>

Here's the overview...

The DBI interface is NOT yet stable. Trying to get it stable without
actually having any implementations was a significant problems. Many
issues are very subtle.

The best approach seemed to be the implementation of a basic DBI plus a
basic database driver and then an interface layer that emulated an
existing interface (oraperl, ingperl, sqlperl etc). This is proving to
be very sucessful in addressing real implementation issues whilst
hiding the actual DBI interface and thus avoiding having to freeze it.

My short term goal is to rework the DBD::Oracle module to take all, or
most, of the Oracle specifics out of the .xs file and do some assorted
clean-ups. At that point I think it would be worthwhile for others to
get involved in implementing drivers with emulation layers.

I have very recently acquired the Microsoft 'ODBC 2.0 Programmer's
Reference and SDK Guide' (approx 800 pages!) and the Borland Database
Engine User Guide (IDAPI). These will help guide the development of the
DBI interface as we apply the experience of implementing real drivers.

I would encourage anyone interested in this to start looking at the
existing DBI and DBD::Oracle modules. If the DBI itself is rather
confusing try ignoring it! Its complexity is mainly to make life easy
for the driver. Concentrate on Oracle.pm and Oracle.xs. The Oracle
specifics should not be too hard to fathom.

I hope that you can work together on this and help one another out
since I may not have time to answer all your questions myself.

Regards,
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <20542-12@lion>;
Wed, 31 May 1995 07:06:44 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 31 May 95 00:58:19 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa06135;
31 May 95 1:57 +0100
Received: by gw.home.vix.com id AA00880; Tue, 30 May 95 11:50:00 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA00874; Tue, 30 May 95 11:49:56 -0700
Received: from msi-gateway1.metropolis.com
by gaia.internex.net (SMI-8.6.9/SMI-SVR4) id LAA15902;
Tue, 30 May 1995 11:49:55 -0700
Received: by msi-gateway1.metropolis.com (IBM OS/2 SENDMAIL VERSION 1.3.2)/1.1)
id AA3918; Tue, 30 May 95 11:55:54 -0700
Message-Id: <[email protected]>
Received: from MSI Notes Network with "Lotus Notes Mail Gateway for SMTP"
id 448A6DB4C82295BB882561CC00673ACE; Tue, 30 May 95 11:55:44
To: Tim Bunce <[email protected]>
Cc: perldb-interest <[email protected]>
From: David Moellenhoff/MSI <[email protected]>
Date: 30 May 95 11:48:57 EDT
Subject: Re: Announce: DBI-0.55.tar.Z and DBD-Oracle-0.16.tar.Z
Mime-Version: 1.0
Content-Type: Text/Plain

You also asked for DBI-related warnings. There are a couple in here,
although it seems to build and test correctly.

-----
Script started on Tue May 30 11:46:29 1995
davem@pebble ~/perl/DBI> make clean

rm -rf *~ t/*~ *.o *.a mon.out core so_locations DBI.bs DBI.bso DBI.exp DBI.c
/blib
mv Makefile Makefile.old 2>/dev/null
davem@pebble ~/perl/DBI> perl Makefile.PL

Build, TEST and INSTALL Perl 5 first. Use version 5.001e or later.

DO NOT build the DBI under the Perl source tree.

Use 'make test' to execute self tests.

MakeMaker
DEFINE => '-Wall -Wno-comment -Wpointer-arith -Wcast-align -Wconversion'
NAME => 'DBI'
VERSION => '0.55'
Using header files found in /usr/local/lib/perl5/sun4-solaris/CORE
Looking for perl 5 by these names:
miniperl perl,
in these dirs:
/usr/ccs/bin /usr/local/bin /usr/gnu/bin /usr/ucb /usr/bin /usr/sbin
/usr/openwin/bin /usr/sybase10/bin /usr/oracle/product/7.1.3/bin
/usr/local/CenterLine/bin /usr/local/CenterLine/sparc-solaris2/bin .
/usr/local/bin
Executing /usr/local/bin/perl
Writing Makefile for DBI
davem@pebble ~/perl/DBI> make

mkdir /export/home/davem/perl/DBI/blib
mkdir /export/home/davem/perl/DBI/blib/auto
mkdir /export/home/davem/perl/DBI/blib/auto/DBI
/usr/local/bin/perl /usr/local/lib/perl5/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/ExtUtils/typemap DBI.xs >DBI.tc && mv DBI.tc DBI.c
gcc -c -DUNEXEC -O3 -fpic -I/usr/local/lib/perl5/sun4-solaris/CORE -Wall
-Wno-comment -Wpointer-arith -Wcast-align -Wconversion DBI.c
DBI.c: In function `dbih_event':
DBI.c:273: warning: unused variable `items'
DBI.c:273: warning: unused variable `ax'
DBI.c: In function `XS_DBI__debug_dispatch':
DBI.c:627: warning: unused variable `sv'
DBI.c: In function `boot_DBI':
DBI.c:819: warning: unused variable `items'
Running mkbootstrap for DBI ()
ld -o /export/home/davem/perl/DBI/blib/auto/DBI/DBI.so -G DBI.o
cp DBI.bs /export/home/davem/perl/DBI/blib/auto/DBI/DBI.bs
mkdir /export/home/davem/perl/DBI/blib/DBI
cp DBIXS.h /export/home/davem/perl/DBI/blib/DBI/DBIXS.h
mkdir /export/home/davem/perl/DBI/blib/DBD
cp lib/DBD/ExampleP.pm /export/home/davem/perl/DBI/blib/DBD/ExampleP.pm
cp DBI.pm /export/home/davem/perl/DBI/blib/DBI.pm
davem@pebble ~/perl/DBI> make test

/usr/local/bin/perl -I/export/home/davem/perl/DBI/blib
-I/export/home/davem/perl/DBI/blib -I/usr/local/lib/perl5/sun4-solaris
-I/usr/local/lib/perl5 -e 'use Test::Harness qw(&runtests $verbose);
$verbose=0; runtests @ARGV;' t/*.t
t/min...............DBD::ExampleP in /usr/local/lib/perl5 is hidden by
DBD::ExampleP in /export/home/davem/perl/DBI/blib
at t/min.t line 16
ok
All tests successful.
Files=1, Tests=6, 1 secs ( 0.34 cusr 0.19 csys = 0.53 cpu)
/usr/local/bin/perl -I/export/home/davem/perl/DBI/blib
-I/export/home/davem/perl/DBI/blib -I/usr/local/lib/perl5/sun4-solaris
-I/usr/local/lib/perl5 test.pl
test.pl
DBI test application $Revision: 1.5 $
Switch: DBI Switch by Tim Bunce, $Revision: 1.36 $
DebugDispatch: 0
DBD::ExampleP in /usr/local/lib/perl5 is hidden by DBD::ExampleP in
/export/home/davem/perl/DBI/blib
at test.pl line 41
Available Drivers: ExampleP, Oracle
Read DBI special variables:
err: 0
err: 99
errstr: 99
Attempt to modify DBI special variables:
Can't modify $DBI::&rows special variable at test.pl line 50

Driver installed as DBI::dr=HASH(0xa9cbc)
Connected as DBI::db=HASH(0x14f350)

Test error handling: prepare invalid query:
ERROR EVENT: DBI::db=HASH(0x14f1f4)->DBI::default_handler:
Unknown field names: unknown_field_name
at /export/home/davem/perl/DBI/blib/DBD/ExampleP.pm line 58
prepare returned UNDEF. $DBI::err=0

Prepared as DBI::st=HASH(0x14108c)
Prepared as DBI::st=HASH(0x1412a8)
Number of fields: 3
Data type of first field: 1
Driver name: ExampleP
Fetching data from both cursors:
16893 2 ., 2 512 .
17901 2 .., 2 512 ..
16832 3 lost+found, 2 512 cron
16893 3776 bin, 2 512 locks
16877 7552 kernel, 2 512 mqueue
17901 30208 lib, 2 512 pkg
16877 135936 sadm, 2 512 uucp
16893 162368 sbin, 2 512 mail
17901 169920 share, 2 512 lp
16893 222784 demo, 2 512 news
16893 226560 games, 2 512 calendar
17407 26440 mail, 2 512 uucppublic

Automatic method parameter usage check:
DBI commit: invalid number of parameters (handle+1)
Usage: $h->commit() at test.pl line 108.

Preparing new $cursor_a to replace current $cursor_a:
(we enable debugging on current to watch it's destruction)
DBI::st=HASH(0x141194) debug level set to 2
-> *DBD::_::st::_untied ((DBD::ExampleP::st)DBI::st=HASH(0x14108c))
<- _untied= undef
-> *DBD::ExampleP::st::DESTROY ((DBD::ExampleP::st)DBI::st=HASH(0x141194))
<- DESTROY= undef
Fetching one row from new $cursor_a:
801354794 .
test done (scoped objects will be destroyed now)
test.pl Done. (global destruction will follow)

davem@pebble ~/perl/DBI> exit
script done on Tue May 30 11:47:13 1995
-----

-Dave

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <20144-28@lion>;
Wed, 31 May 1995 07:07:25 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Wed, 31 May 95 01:47:12 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa17028;
31 May 95 2:46 +0100
Received: by gw.home.vix.com id AA00760; Tue, 30 May 95 11:47:33 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA00755; Tue, 30 May 95 11:47:32 -0700
Received: from msi-gateway1.metropolis.com
by gaia.internex.net (SMI-8.6.9/SMI-SVR4) id LAA15735;
Tue, 30 May 1995 11:47:23 -0700
Received: by msi-gateway1.metropolis.com (IBM OS/2 SENDMAIL VERSION 1.3.2)/1.1)
id AA3912; Tue, 30 May 95 11:53:22 -0700
Message-Id: <[email protected]>
Received: from MSI Notes Network with "Lotus Notes Mail Gateway for SMTP"
id 77E6F4484170B2E4882561CC006698BC; Tue, 30 May 95 11:53:13
To: Tim Bunce <[email protected]>
Cc: perldb-interest <[email protected]>
From: David Moellenhoff/MSI <[email protected]>
Date: 30 May 95 11:46:24 EDT
Subject: Re: Announce: DBI-0.55.tar.Z and DBD-Oracle-0.16.tar.Z
Mime-Version: 1.0
Content-Type: Text/Plain

I haven't had the chance to look into this any farther, but here's the
result of the Solaris 2.3/gcc 2.6.0/Oracle 7.1.3 build:

-----
Script started on Tue May 30 11:38:56 1995
davem@pebble ~/perl/Oracle> make clean

rm -rf *~ t/*~ *.o *.a mon.out core so_locations Oracle.bs Oracle.bso
Oracle.exp Oracle.c ./blib
mv Makefile Makefile.old 2>/dev/null
davem@pebble ~/perl/Oracle> perl Makefile.PL

Configuring DBD::Oracle version 0.16...
Remember to actually read the README file!

Using Oracle in /usr/oracle/product/7.1.3
Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio
Using proc.mk version 1.11
System: perl5.001 sunos pebble 5.3 generic_101318-59 sun4m sparc gcc -O3
-DUNEXEC

Writing Makefile for DBD::Oracle
davem@pebble ~/perl/Oracle> make
mkdir /export/home/davem/perl/Oracle/blib
mkdir /export/home/davem/perl/Oracle/blib/DBD
mkdir /export/home/davem/perl/Oracle/blib/auto
mkdir /export/home/davem/perl/Oracle/blib/auto/DBD
mkdir /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle
/usr/local/bin/perl /usr/local/lib/perl5/ExtUtils/xsubpp -typemap
/usr/local/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc
Oracle.c
gcc -c -DUNEXEC -O3 -fpic -I/usr/local/lib/perl5/sun4-solaris/CORE -Wall
-Wno-comment -Wpointer-arith -Wcast-align -Wconversion
-I/usr/oracle/product/7.1.3/rdbms/demo -I/usr/local/lib/perl5/sun4-solaris/DBI
Oracle.c
Oracle.c: In function `XS_DBD__Oracle__db_FETCH':
Oracle.c:211: warning: unused variable `imp_dbh'
Oracle.c: In function `XS_DBD__Oracle__st_STORE':
Oracle.c:417: warning: unused variable `dbh'
gcc -c -DUNEXEC -O3 -fpic -I/usr/local/lib/perl5/sun4-solaris/CORE -Wall
-Wno-comment -Wpointer-arith -Wcast-align -Wconversion
-I/usr/oracle/product/7.1.3/rdbms/demo -I/usr/local/lib/perl5/sun4-solaris/DBI
dbdimp.c
dbdimp.c: In function `do_error':
dbdimp.c:46: warning: passing arg 2 of `oerhms' with different width due to
prototype
Running mkbootstrap for DBD::Oracle ()
ld -o /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.so -G
Oracle.o dbdimp.o -L/usr/oracle/product/7.1.3/lib
/usr/oracle/product/7.1.3/lib/__fstd.o -locic
/usr/oracle/product/7.1.3/lib/osntab.o -lsqlnet -lsqlnet -lnlsrtl -lcv6
-lcore -lnlsrtl -lcv6 -lcore `cat
/usr/oracle/product/7.1.3/rdbms/lib/sysliblist` -lsocket -lnsl -lm -ldl -laio
cp Oracle.bs /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.bs
cp Oraperl.pm /export/home/davem/perl/Oracle/blib/Oraperl.pm
cp Oracle.pm /export/home/davem/perl/Oracle/blib/DBD/Oracle.pm
davem@pebble ~/perl/Oracle> make test TEST_VERBOSE=1

/usr/local/bin/perl -I/export/home/davem/perl/Oracle/blib
-I/export/home/davem/perl/Oracle/blib -I/usr/local/lib/perl5/sun4-solaris
-I/usr/local/lib/perl5 -e 'use Test::Harness qw(&runtests $verbose);
$verbose=1; runtests @ARGV;' t/*.t
t/base..............install_driver(Oracle) failed: Can't load
'/export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal: relocation error: symbol not
found: upibrk: referenced in /export/home/davem/perl/Oracle/
blib/auto/DBD/Oracle/Oracle.so at /usr/local/lib/perl5/DynaLoader.pm line 128.

at /export/home/davem/perl/Oracle/blib/DBD/Oracle.pm line 16
at /usr/local/lib/perl5/DBI.pm line 167
DBI::install_driver called at t/base.t line 16
1..5
ok 1
ok 2
ok 3
FAILED on test 4
t/main..............t/main.t
DBI test application $Revision: 1.15 $
1..1
ok 1
ok
Failed 1 test, 50.00% okay.
Files=2, Tests=6, 1 secs ( 0.80 cusr 0.35 csys = 1.15 cpu)
/usr/local/bin/perl -I/export/home/davem/perl/Oracle/blib
-I/export/home/davem/perl/Oracle/blib -I/usr/local/lib/perl5/sun4-solaris
-I/usr/local/lib/perl5 test.pl
Oraperl test application $Revision: 1.10 $
install_driver(Oracle) failed: Can't load
'/export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.so' for module
DBD::Oracle: ld.so.1: /usr/local/bin/perl: fatal: relocation error: symbol not
found: upibrk: referenced in
/export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.so at
/usr/local/lib/perl5/DynaLoader.pm line 128.

at /export/home/davem/perl/Oracle/blib/DBD/Oracle.pm line 16
at /usr/local/lib/perl5/DBI.pm line 167
DBI::install_driver called at /export/home/davem/perl/Oracle/blib/Oraperl.pm
line 41
(eval) called at (eval 1) line 1
main::BEGIN called at /export/home/davem/perl/Oracle/blib/Oraperl.pm line 0
(eval) called at /export/home/davem/perl/Oracle/blib/Oraperl.pm line 0
(eval) called at test.pl line 23
BEGIN failed--compilation aborted at (eval 1) line 1.
*** Error code 2
make: Fatal error: Command failed for target `test'
davem@pebble ~/perl/Oracle> exit
script done on Tue May 30 11:39:51 1995
-----

I don't recognize that unresolved symbol 'upibrk'. Anyone know who it belongs
to?

-Dave

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <28572-17@lion>;
Fri, 2 Jun 1995 07:03:06 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Fri, 02 Jun 95 00:20:20 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa12436;
2 Jun 95 1:20 +0100
Received: by gw.home.vix.com id AA14073; Thu, 1 Jun 95 10:05:41 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA14069; Thu, 1 Jun 95 10:05:40 -0700
Received: from msi-gateway1.metropolis.com
by gaia.internex.net (SMI-8.6.9/SMI-SVR4) id KAA10750;
Thu, 1 Jun 1995 10:05:31 -0700
Received: by msi-gateway1.metropolis.com (IBM OS/2 SENDMAIL VERSION 1.3.2)/1.1)
id AA4379; Thu, 01 Jun 95 10:11:46 -0700
Message-Id: <[email protected]>
Received: from MSI Notes Network with "Lotus Notes Mail Gateway for SMTP"
id 66F95B639149DB75882561CE005CEFCB; Thu, 1 Jun 95 10:11:35
To: Tim Bunce <[email protected]>
Cc: perldb-interest <[email protected]>
From: David Moellenhoff/MSI <[email protected]>
Date: 1 Jun 95 10:04:19 EDT
Subject: Re: Announce: DBI-0.55.tar.Z and DBD-Oracle-0.16.tar.Z
Mime-Version: 1.0
Content-Type: Text/Plain

Well, I found the direct cause of my Solaris 2.3/gcc 2.6.0/Oracle 7.1.3
problems. 'upibrk' was undefined because libora.a was not being linked
in the Oracle.so. Hacking the makefile to put '-lora' in fixes the unresolved
symbols. Here's the ld command I used:

ld -o /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.so -G
Oracle.o dbdimp.o -L/usr/oracle/product/7.1.3/lib
/usr/oracle/product/7.1.3/lib/__fstd.o -locic -lora
/usr/oracle/product/7.1.3/lib/osntab.o -lsqlnet -lsqlnet -lnlsrtl -lcv6
-lcore -lora -lnlsrtl -lcv6 -lcore -lora `cat
/usr/oracle/product/7.1.3/rdbms/lib/sysliblist` -lsocket -lnsl -lm -ldl -laio

Now I have another problem. It seems that whenever I use anything
for the dbname parameter in &ora_login, I get the following error:

Oraperl test application $Revision: 1.10 $
DBD::Oracle driver installed as DBI::dr=HASH(0x1394c8)
DBI::dr=HASH(0x142f74) debug level set to 1

Oraperl Emulation Interface $Revision: 1.13 $
Oracle Driver $Revision: 1.13 $
DBI Switch by Tim Bunce, $Revision: 1.36 $

ERROR EVENT: DBI::dr=HASH(0x142f74)->DBI::default_handler:
2726 ORA-02726: osnpop: access error on oracle executable (DBD: login failed)
at /export/home/davem/perl/Oracle/blib/DBD/Oracle.pm line 84
ora_login: 2726: ORA-02726: osnpop: access error on oracle executable (DBD:
login failed)
*** Error code 2

If I edit test.pl to remove $dbname from the &ora_login (and use just
''), the test succeeds. I've even tried passing $ENV{ORACLE_SID}
in directly (and also a straight ASCII string) and it still refuses to
login. I've tried other oraperl scripts and they exhibit the same behavior.
Anytime dbname is explicit, the login fails. If dbname is not specified,
everything works fine. Any thoughts?

-Dave

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <28572-24@lion>;
Fri, 2 Jun 1995 07:04:08 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Fri, 02 Jun 95 00:45:35 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa19067;
2 Jun 95 1:44 +0100
Received: by gw.home.vix.com id AA22575; Thu, 1 Jun 95 12:31:01 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA22568; Thu, 1 Jun 95 12:30:59 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa08179;
1 Jun 95 20:30 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id aa25970;
1 Jun 95 20:30 +0100
Received: from ig.co.uk by lion id <24770-0@lion>;
Thu, 1 Jun 1995 20:28:56 +0100
To: [email protected]
Subject: Re: Announce: DBI-0.55.tar.Z and DBD-Oracle-0.16.tar.Z
Cc: [email protected]
Date: Thu, 1 Jun 1995 20:28:56 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: David Moellenhoff/MSI <[email protected]>
>
> Well, I found the direct cause of my Solaris 2.3/gcc 2.6.0/Oracle 7.1.3
> problems. 'upibrk' was undefined because libora.a was not being linked
> in the Oracle.so. Hacking the makefile to put '-lora' in fixes the unresolved
> symbols. Here's the ld command I used:
>
> ld -o /export/home/davem/perl/Oracle/blib/auto/DBD/Oracle/Oracle.so -G
> Oracle.o dbdimp.o -L/usr/oracle/product/7.1.3/lib
> /usr/oracle/product/7.1.3/lib/__fstd.o -locic -lora
> /usr/oracle/product/7.1.3/lib/osntab.o -lsqlnet -lsqlnet -lnlsrtl -lcv6
> -lcore -lora -lnlsrtl -lcv6 -lcore -lora `cat
> /usr/oracle/product/7.1.3/rdbms/lib/sysliblist` -lsocket -lnsl -lm -ldl -laio
>
In any messages related to linking problems it's vital that you tell
me which version of proc.mk you're using (Makefile.PL tells you).
It's probably a good idea to mail me a copy of it anyway even if
you have done so before since I tend to delete mail once I've dealt
with it (I get around 50 to 100 messages a day).

> Now I have another problem. It seems that whenever I use anything
> for the dbname parameter in &ora_login, I get the following error:
>
> ERROR EVENT: DBI::dr=HASH(0x142f74)->DBI::default_handler:
> 2726 ORA-02726: osnpop: access error on oracle executable (DBD: login failed)
> at /export/home/davem/perl/Oracle/blib/DBD/Oracle.pm line 84
> ora_login: 2726: ORA-02726: osnpop: access error on oracle executable (DBD:
> login failed)
>
> If I edit test.pl to remove $dbname from the &ora_login (and use just
> ''), the test succeeds. I've even tried passing $ENV{ORACLE_SID}
> in directly (and also a straight ASCII string) and it still refuses to
> login. I've tried other oraperl scripts and they exhibit the same behavior.
> Anytime dbname is explicit, the login fails. If dbname is not specified,
> everything works fine. Any thoughts?
>
For this kind of problem I need to know what the $dbname looked like
(did it contain a colon) and what version of SQL*Net you're using.

Does 'other oraperl scripts' refer to perl4 oraperl?

> -Dave
>
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <09268-14@lion>;
Fri, 2 Jun 1995 23:30:56 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Fri, 02 Jun 95 22:12:21 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa04311;
2 Jun 95 23:12 +0100
Received: by gw.home.vix.com id AA06942; Fri, 2 Jun 95 10:22:07 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA06937; Fri, 2 Jun 95 10:22:03 -0700
From: [email protected]
Received: from texbell.sbc.com (texbell.sbc.com [132.201.42.10])
by wuarchive.wustl.edu (8.6.11/8.6.9) with SMTP id MAA09636
for <[email protected]>; Fri, 2 Jun 1995 12:20:29 -0500
Received: from vlad.sbc.com by texbell.sbc.com (4.1/SMI-4.1) id AA28317;
Fri, 2 Jun 95 11:55:48 CDT
Received: by vlad.sbc.com (5.x/SMI-4.1) id AA09009;
Fri, 2 Jun 1995 11:50:26 -0500
Date: Fri, 2 Jun 1995 11:50:26 -0500
Message-Id: <[email protected]>
To: [email protected]
Subject: Newbee installation ok?
Reply-To: [email protected]

Hello, I've tried to install DBI 0.55 on my solaris x86 box. I got
some messages that I don't know if they are ok, nor do I know if I
followed the correct procedure for installation.
---------------------
vlad: uname -a
SunOS vlad 5.4 Generic_101946-08 i86pc i386

---------------------
vlad: perl -v

This is perl, version 5.001

Unofficial patchlevel 1e.

Copyright 1987-1994, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5.0 source kit.

---------------------
Placed the DBI directory in a nice place, NOT under the perl tree.
Did the following steps:

perl Makefile.pl

make

make test

The results of the make test:
--------------------
vlad: make test
/usr/local/bin/perl -I./blib -I./blib -I/usr/local/lib/perl5/i86pc-solaris -I/usr/local/lib/perl5 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t
t/min...............ok
All tests successful.
Files=1, Tests=6, 0 secs ( 0.30 cusr 0.22 csys = 0.52 cpu)
/usr/local/bin/perl -I./blib -I./blib -I/usr/local/lib/perl5/i86pc-solaris -I/usr/local/lib/perl5 test.pl
test.pl
DBI test application $Revision: 1.5 $
Switch: DBI Switch by Tim Bunce, $Revision: 1.36 $
DebugDispatch: 0
Available Drivers: ExampleP
Read DBI special variables:
err: 0
err: 99
errstr: 99
Attempt to modify DBI special variables:
Can't modify $DBI::&rows special variable at test.pl line 50

Driver installed as DBI::dr=HASH(0x80bc0e8)
Connected as DBI::db=HASH(0x815777c)

Test error handling: prepare invalid query:
ERROR EVENT: DBI::db=HASH(0x8157620)->DBI::default_handler:
Unknown field names: unknown_field_name
at blib/DBD/ExampleP.pm line 58
prepare returned UNDEF. $DBI::err=0

Prepared as DBI::st=HASH(0x814a4b8)
Prepared as DBI::st=HASH(0x814a6d4)
Number of fields: 3
Data type of first field: 1
Driver name: ExampleP
Fetching data from both cursors:
16893 2 ., 2 512 .
16877 2 .., 2 512 ..
16832 3 lost+found, 2 512 cron
16893 7424 kvm, 2 512 locks
16893 29696 bin, 2 512 mqueue
16877 37120 ccs, 2 512 pkg
16877 51968 kernel, 2 512 uucp
16893 89088 lib, 2 512 uucppublic
16877 44553 sadm, 2 512 lp
16893 14860 sbin, 2 512 rlp
16877 89145 share, 2 512 calendar

Automatic method parameter usage check:
DBI commit: invalid number of parameters (handle+1)
Usage: $h->commit() at test.pl line 108.

Preparing new $cursor_a to replace current $cursor_a:
(we enable debugging on current to watch it's destruction)
DBI::st=HASH(0x814a5c0) debug level set to 2
-> *DBD::_::st::_untied ((DBD::ExampleP::st)DBI::st=HASH(0x814a4b8))
<- _untied= undef
-> *DBD::ExampleP::st::DESTROY ((DBD::ExampleP::st)DBI::st=HASH(0x814a5c0))
<- DESTROY= undef
Fetching one row from new $cursor_a:
799338430 .
test done (scoped objects will be destroyed now)
test.pl Done. (global destruction will follow)

---------------------------

Is it OK? Did I follow the correct procedures?

Thanks
--
Brian Millett "The significant problems we face in life
Southwestern Bell Telephone Co. cannot be solved at the same level of
(314) 235-3866 thinking we were at when we created them"
[email protected] Albert Einstein.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <11085-9@lion>;
Sat, 3 Jun 1995 11:32:24 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Sat, 03 Jun 95 00:31:19 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa02561;
3 Jun 95 1:31 +0100
Received: by gw.home.vix.com id AA17641; Fri, 2 Jun 95 13:26:23 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA17637; Fri, 2 Jun 95 13:26:22 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id aa28487;
2 Jun 95 21:24 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id aa14815;
2 Jun 95 21:24 +0100
Received: from ig.co.uk by lion id <08435-0@lion>;
Fri, 2 Jun 1995 20:13:57 +0100
To: [email protected]
Subject: Quick DBI fix for Perl5.001i AutoLoader problems
Date: Fri, 2 Jun 1995 20:13:57 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

If you build Perl5.001i and use the latest DBI and DBD::Oracle
you'll get this error:

Have not loaded Oraperl.pm at /usr/local/lib/perl5/Oraperl.pm line 16

This is a symptom of an AutoLoader problem which is being worked on.
In the mean time the best fix is to add the following line to DBI.pm:

sub import { }

Tim.

(Patches for Perl5.001i should be available from the usual major
archives sites such as ftp://ftp.cis.ufl.edu/pub/perl)

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <11085-21@lion>;
Sat, 3 Jun 1995 11:33:07 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Sat, 03 Jun 95 02:14:04 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa01500;
3 Jun 95 3:13 +0100
Received: by gw.home.vix.com id AA25476; Fri, 2 Jun 95 15:43:17 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA25472; Fri, 2 Jun 95 15:43:14 -0700
Received: from post.demon.co.uk by disperse.demon.co.uk id ab15624;
2 Jun 95 23:42 +0100
Received: from ignite.demon.co.uk by post.demon.co.uk id ab17798;
2 Jun 95 23:42 +0100
Received: from ig.co.uk by lion id <09668-0@lion>;
Fri, 2 Jun 1995 23:41:47 +0100
To: [email protected], [email protected]
Subject: Re: Newbee installation ok?
Date: Fri, 2 Jun 1995 23:41:47 +0100
From: Tim Bunce <[email protected]>
Sender: [email protected]
Organisation: Paul Ingram Group, Software Systems, +44 483 424424
Message-Id: <[email protected]>

> From: [email protected]
>
> Hello, I've tried to install DBI 0.55 on my solaris x86 box. I got
> some messages that I don't know if they are ok, nor do I know if I
> followed the correct procedure for installation.

They're fine. The next release has explicit 'Expect ...' messages to
make it clear what should happen.

Thanks for letting me know how it went.

What are you going to do with it now ? :-)

> Brian Millett "The significant problems we face in life
> Southwestern Bell Telephone Co. cannot be solved at the same level of
> (314) 235-3866 thinking we were at when we created them"
> [email protected] Albert Einstein.
>
Tim.

---+++---
Received: from post.demon.co.uk by lion with SMTP (PP) id <16455-0@lion>;
Mon, 5 Jun 1995 07:47:53 +0100
Received: from post.demon.co.uk via puntmail for [email protected];
Mon, 05 Jun 95 06:42:57 GMT
Received: from gw.home.vix.com by post.demon.co.uk id aa05247;
5 Jun 95 7:42 +0100
Received: by gw.home.vix.com id AA17363; Sun, 4 Jun 95 20:46:15 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA17359; Sun, 4 Jun 95 20:46:09 -0700
Received: by melcogw.melit.melco.co.jp (5.65+1.6W/2.7W) id AA09597;
Mon, 5 Jun 95 12:47:02 JST
Received: from picme by inetgw.topo.melco.co.jp (16.8/6.4J.6-inetgw1.0)
id AA23764; Mon, 5 Jun 95 12:36:11 +0900
Received: from wse821.pic.melco.co.jp (wse821)
by picme.pic.melco.co.jp (5.61/6.4J.6-cae1) id AA25235;
Mon, 5 Jun 95 12:47:32 +0900
Received: by wse821.pic.melco.co.jp (1.38.193.4/6.4J.6-melco1) id AA02065;
Mon, 5 Jun 1995 12:46:06 +0900
Return-Path: <[email protected]>
Message-Id: <[email protected]>
To: [email protected]
Subject: help
Date: Mon, 05 Jun 1995 12:46:05 +0900
From: Qi Jian Ping <[email protected]>

help

---+++---
Received: from punt.demon.co.uk by lion with SMTP (PP) id <24306-6@lion>;
Fri, 9 Jun 1995 07:17:00 +0100
Received: from punt.demon.co.uk via puntmail for [email protected];
Thu, 08 Jun 95 22:45:07 GMT
Received: from gw.home.vix.com by punt.demon.co.uk id aa03475;
8 Jun 95 23:44 +0100
Received: by gw.home.vix.com id AA16309; Thu, 8 Jun 95 09:43:25 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA16303; Thu, 8 Jun 95 09:43:24 -0700
Received: from localhost by colossus.cse.psu.edu with SMTP id <45711>;
Thu, 8 Jun 1995 12:41:54 -0400
X-Mailer: exmh version 1.6.1 5/23/95
To: [email protected]
Cc: [email protected]
Subject: Solaris 2.4 tests fail
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Thu, 8 Jun 1995 12:40:18 -0400
From: John D Groenveld <[email protected]>
Message-Id: <[email protected]>

I'm having trouble moving from SunOs 4.1.3/Oracle 7.0.16 to Solaris 2.4/Oracle
7.1.4. I'm using Perl 5.001e (perl5.001i wouldnt build properly),SunC3.0.1,
DBD-Oracle-0.16, and DBI-0.55.

Below is my log...
Thanks in advance,
John
[email protected]

* perl -v
This is perl, version 5.001

Unofficial patchlevel 1e.

Copyright 1987-1994, Larry Wall

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5.0 source kit.

* perl -e 'use Config; print Config::myconfig()'
Summary of my perl5 (patchlevel 1) configuration:
Platform:
osname=solaris, osver=2.4, archname=sun4-solaris
uname='sunos elvis 5.4 generic_101945-27 sun4d sparc '
hint=previous
Compiler:
cc='cc', optimize='-O'
cppflags=''
ccflags =''
ldflags =''
stdchar='unsigned char', d_stdstdio=define, usevfork=false
voidflags=15, castflags=0, d_casti32=define, d_castneg=define
intsize=4, alignbytes=8, usemymalloc=n, randbits=15
Libraries:
so=so
libpth=/lib /usr/lib /usr/ccs/lib /opt/gnu/lib /usr/ucblib
libs=-L/lib -L/usr/lib -L/usr/ccs/lib -R/lib -R/usr/lib -R/usr/ccs/lib
-lsocket -lnsl -ldl -lm -lc -lcrypt -L/opt/gnu/lib -L/usr/ucblib
-R/opt/gnu/lib -R/usr/ucblib -lgdbm -ldbm
libc=/usr/lib/libc.so
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=
cccdlflags='-K pic', ccdlflags=' ', lddlflags='-G'

* perl Makefile.PL
Configuring DBD::Oracle version 0.16...
Remember to actually read the README file!

Using Oracle in /home3/oracle/product/7.1.4
Oracle sysliblist: -lsocket -lnsl -lm -ldl -laio -lposix4
Using proc.mk version 1.17
System: perl5.001 sunos elvis 5.4 generic_101945-27 sun4d sparc cc -O
See README notes about SPARCompiler on Solaris

Writing Makefile for DBD::Oracle
mkdir ./blib
mkdir ./blib/DBD
mkdir ./blib/auto
mkdir ./blib/auto/DBD
mkdir ./blib/auto/DBD/Oracle
/bin/perl /opt/gnu/lib/perl5/ExtUtils/xsubpp -typemap
/opt/gnu/lib/perl5/ExtUtils/typemap Oracle.xs >Oracle.tc && mv Oracle.tc
Oracle.c
cc -c -O -K pic -I/opt/gnu/lib/perl5/sun4-solaris/CORE
-I/home3/oracle/product/7.1.4/rdbms/demo -I/opt/gnu/lib/perl5/sun4-solaris/DBI
Oracle.c
"Oracle.c", line 104: warning: argument #1 is incompatible with prototype:
prototype: pointer to const char : "/usr/include/string.h", line 59
argument : pointer to uchar
"Oracle.c", line 198: warning: statement not reached
"Oracle.c", line 438: warning: statement not reached
cc -c -O -K pic -I/opt/gnu/lib/perl5/sun4-solaris/CORE
-I/home3/oracle/product/7.1.4/rdbms/demo -I/opt/gnu/lib/perl5/sun4-solaris/DBI
dbdimp.c
"dbdimp.c", line 47: warning: argument #1 is incompatible with prototype:
prototype: pointer to const char : "/usr/include/string.h", line 59
argument : pointer to uchar
"dbdimp.c", line 51: warning: argument #1 is incompatible with prototype:
prototype: pointer to char : "/usr/include/string.h", line 32
argument : pointer to uchar
"dbdimp.c", line 103: warning: assignment type mismatch:
pointer to uchar "=" pointer to char
"dbdimp.c", line 110: warning: assignment type mismatch:
pointer to char "=" pointer to uchar
"dbdimp.c", line 191: warning: argument #2 is incompatible with prototype:
prototype: pointer to uchar : "/home3/oracle/product/7.1.4/rdbms/demo/ociapr.h
", line 36
argument : pointer to char
Running mkbootstrap for DBD::Oracle ()
cc -o blib/auto/DBD/Oracle/Oracle.so -G Oracle.o dbdimp.o
-L/home3/oracle/product/7.1.4/lib /home3/oracle/product/7.1.4/lib/__fstd.o
-locic /home3/oracle/product/7.1.4/lib/osntab.o -lsqlnet -lsqlnet -lnlsrtl
-lcv6 -lcore -lnlsrtl -lcv6 -lcore `cat
/home3/oracle/product/7.1.4/rdbms/lib/sysliblist` -Y P,:/usr/ccs/lib:/usr/lib
-Qy -lc /home3/oracle/product/7.1.4/lib/crtn.o -lsocket -lnsl -lm -ldl -laio
-lposix4
cp Oracle.bs ./blib/auto/DBD/Oracle/Oracle.bs
cp Oraperl.pm blib/Oraperl.pm
cp Oracle.pm blib/DBD/Oracle.pm

* make test
/bin/perl -I./blib -I./blib -I/opt/gnu/lib/perl5/sun4-solaris
-I/opt/gnu/lib/perl5 -e 'use Test::Harness qw(&runtests $verbose); $verbose=0;
runtests @ARGV;' t/*.t
t/base..............install_driver(Oracle) failed: Can't load
'./blib/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /bin/perl:
fatal: relocation error: symbol not found: upibrk: referenced in
/blib/auto/DBD/Oracle/Oracle.so at /opt/gnu/lib/perl5/DynaLoader.pm line 128.

at blib/DBD/Oracle.pm line 16
at /opt/gnu/lib/perl5/DBI.pm line 167
DBI::install_driver called at t/base.t line 16
FAILED on test 4
t/main..............ok
Failed 1 test, 50.00% okay.
Files=2, Tests=6, 1 secs ( 0.76 cusr 0.20 csys = 0.96 cpu)
/bin/perl -I./blib -I./blib -I/opt/gnu/lib/perl5/sun4-solaris
-I/opt/gnu/lib/perl5 test.pl
Oraperl test application $Revision: 1.10 $
install_driver(Oracle) failed: Can't load './blib/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: ld.so.1: /bin/perl: fatal: relocation error: symbol
not found: upibrk: referenced in ./blib/auto/DBD/Oracle/Oracle.so at
/opt/gnu/lib/perl5/DynaLoader.pm line 128.

at blib/DBD/Oracle.pm line 16
at /opt/gnu/lib/perl5/DBI.pm line 167
DBI::install_driver called at blib/Oraperl.pm line 41
(eval) called at (eval 1) line 1
main::BEGIN called at blib/Oraperl.pm line 0
(eval) called at blib/Oraperl.pm line 0
(eval) called at test.pl line 23
BEGIN failed--compilation aborted at (eval 1) line 1.
*** Error code 2
make: Fatal error: Command failed for target `test'

* make test TEST_VERBOSE=1
/bin/perl -I./blib -I./blib -I/opt/gnu/lib/perl5/sun4-solaris
-I/opt/gnu/lib/perl5 -e 'use Test::Harness qw(&runtests $verbose); $verbose=1;
runtests @ARGV;' t/*.t
t/base..............install_driver(Oracle) failed: Can't load
'./blib/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1: /bin/perl:
fatal: relocation error: symbol not found: upibrk: referenced in
/blib/auto/DBD/Oracle/Oracle.so at /opt/gnu/lib/perl5/DynaLoader.pm line 128.

at blib/DBD/Oracle.pm line 16
at /opt/gnu/lib/perl5/DBI.pm line 167
DBI::install_driver called at t/base.t line 16
1..5
ok 1
ok 2
ok 3
FAILED on test 4
t/main..............t/main.t
DBI test application $Revision: 1.15 $
1..1
ok 1
ok
Failed 1 test, 50.00% okay.
Files=2, Tests=6, 1 secs ( 0.76 cusr 0.18 csys = 0.94 cpu)
/bin/perl -I./blib -I./blib -I/opt/gnu/lib/perl5/sun4-solaris
-I/opt/gnu/lib/perl5 test.pl
Oraperl test application $Revision: 1.10 $
install_driver(Oracle) failed: Can't load './blib/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: ld.so.1: /bin/perl: fatal: relocation error: symbol
not found: upibrk: referenced in ./blib/auto/DBD/Oracle/Oracle.so at
/opt/gnu/lib/perl5/DynaLoader.pm line 128.

at blib/DBD/Oracle.pm line 16
at /opt/gnu/lib/perl5/DBI.pm line 167
DBI::install_driver called at blib/Oraperl.pm line 41
(eval) called at (eval 1) line 1
main::BEGIN called at blib/Oraperl.pm line 0
(eval) called at blib/Oraperl.pm line 0
(eval) called at test.pl line 23
BEGIN failed--compilation aborted at (eval 1) line 1.
*** Error code 2
make: Fatal error: Command failed for target `test'

---+++---
Received: from punt.demon.co.uk by lion with SMTP (PP) id <25218-0@lion>;
Fri, 9 Jun 1995 07:22:07 +0100
Received: from punt.demon.co.uk via puntmail for [email protected];
Fri, 09 Jun 95 01:59:34 GMT
Received: from gw.home.vix.com by punt.demon.co.uk id aa28427;
9 Jun 95 2:58 +0100
Received: by gw.home.vix.com id AA12855; Thu, 8 Jun 95 16:10:22 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA12838; Thu, 8 Jun 95 16:10:21 -0700
Received: from ivy.interbase.borland.com by caymen.interbase.borland.com
with smtp (Smail3.1.28.1 #1) id m0sJqh2-00000xC;
Thu, 8 Jun 95 16:08 PDT
Received: by ivy.interbase.borland.com (4.1/SMI-4.1) id AA10559;
Thu, 8 Jun 95 16:09:17 PDT
Date: Thu, 8 Jun 95 16:09:17 PDT
From: Bill Karwin <[email protected]>
Message-Id: <[email protected]>
To: [email protected], [email protected]
Subject: Re: Interbase SQL

Hi Garth:

My name is Bill Karwin, and I'm an InterBase tech support engineer
at Borland. I am working on a DBD package for InterBase, as a tool
for my own use, a freebie for InterBase customers, and a contribution
to the perldb community.

I have been given the okay to make this DBD freely redistributable, but
not quite been given permission to spend company time working on it.
Right now, I don't have anything except two old implementations of
Perl 4 usubs for the InterBase API I got one of these on an ftp site,
and the other from one of Borland's customers -- I don't think I have
permission to redistribute that, but I will use it as reference while
developing the InterBase DBD.

I'm working on SunOS 4.1.4, and after I have the DBD in relatively
stable condition, I'll verify it on some of the other OS's for which
there are InterBase ports.

Cheers,
-Bill

Date: Thu, 8 Jun 1995 14:12:41 -0700
From: Garth Johnson <[email protected]>
Subject: Interbase SQL

I have been a long time user of oraperl in my 'real' job, but I have
recently acquired a copy of Borland's Interbase SQL server. Is there a
interface or library for this server?

---+++---
Received: from punt.demon.co.uk by lion with SMTP (PP) id <24405-20@lion>;
Fri, 9 Jun 1995 07:25:25 +0100
Received: from punt.demon.co.uk via puntmail for [email protected];
Fri, 09 Jun 95 03:47:37 GMT
Received: from gw.home.vix.com by punt.demon.co.uk id aa19761;
9 Jun 95 4:46 +0100
Received: by gw.home.vix.com id AA03609; Thu, 8 Jun 95 14:05:23 -0700
X-Btw: vix.com is also gw.home.vix.com and vixie.sf.ca.us
Received: by gw.home.vix.com id AA03603; Thu, 8 Jun 95 14:05:22 -0700
Received: with ESMTP (1.37.109.15/16.2) id AA207425406;
Thu, 8 Jun 1995 14:03:27 -0700
Received: with ESMTP (1.37.109.15/16.2) id AA125475456;
Thu, 8 Jun 1995 14:04:16 -0700
Received: (1.37.109.15/16.2) id AA223925961; Thu, 8 Jun 1995 14:12:41 -0700
Date: Thu, 8 Jun 1995 14:12:41 -0700
From: Garth Johnson <[email protected]>
Message-Id: <[email protected]>
To: [email protected]
Subject: Interbase SQL
X-Mailer: Siren Mail (Motif 2.02 95/05/15)
Mime-Version: 1.0
Content-Id: <205_17218_802645961_7@wssan19>
Content-Type: text/plain; charset="us-ascii"

I have been a long time user of oraperl in my 'real' job, but I have
recently acquired a copy of Borland's Interbase SQL server. Is there a
interface or library for this server?

later
Garth

---+++---