DBD::Oracle (perl 5.8.0, Oracle 8.0.3, DBD-Oracle 1.12, Solaris 8) make problems (fprintf)

The only fprintf warning I googled was at 
http://archive.develooper.com/dbi-announce@perl.org/msg00081.html

Any suggestions appreciated.  I'm assuming since the perl Makefile.PL ran 
clean, I'm using kosher Oracle libraries (binaries worked with Perl 5.6.0).

Thanks,

Dave S.

Appended output of (in order):
	make output
	perl Makefile.PL
	perl -V
     gcc -v

>make
gcc -c  -I/app/oracle/product/8.0.3/rdbms/demo -I/app/oracle/product/8.0.3/rdbms
/public -I/app/oracle/product/8.0.3/plsql/public -I/app/oracle/product/8.0.3/net
work/public -I/app/oracle/product/8.0.3/rdbms/demo -I/app/oracle/product/8.0.3/r
dbms/include -I/app/oracle/product/8.0.3/rdbms/demo -I/share/usr/local/lib/perl5
/site_perl/5.8.0/sun4-solaris/auto/DBI -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -O   -DVERSION=\"1.12\" -DXS_VERSION=\"1.12\" -fPIC "-I/s
hare/usr/local/lib/perl5/5.8.0/sun4-solaris/CORE"   oci8.c
oci8.c: In function `oci_hdtype_name':
oci8.c:100: `OCI_HTYPE_SUBSCRIPTION' undeclared (first use in this function)
oci8.c:100: (Each undeclared identifier is reported only once
oci8.c:100: for each function it appears in.)
oci8.c:109: `OCI_DTYPE_LOCATOR' undeclared (first use in this function)
oci8.c: In function `oci_error_get':
oci8.c:136: warning: passing arg 1 of `fprintf' from incompatible pointer type
oci8.c:144: warning: passing arg 1 of `fprintf' from incompatible pointer type
oci8.c: In function `ora_st_prepare':
oci8.c:304: warning: passing arg 1 of `fprintf' from incompatible pointer type
oci8.c:307: warning: passing arg 1 of `fprintf' from incompatible pointer type
oci8.c:310: warning: passing arg 1 of `fprintf' from incompatible pointer type
oci8.c:314: warning: passing arg 1 of `fprintf' from incompatible pointer type
oci8.c:317: warning: passing arg 1 of `fprintf' from incompatible pointer type
oci8.c:335: warning: passing arg 1 of `fprintf' from incompatible pointer type
....etc.
-----------------------------
>perl Makefile.PL
Using DBI 1.32 installed in /share/usr/local/lib/perl5/site_perl/5.8.0/sun4-
solaris/auto/DBI
Duplicate specification "S=s" for option "s"

 Configuring DBD::Oracle ...

>>>     Remember to actually *READ* the README file!
        Especially if you have any problems.

Using Oracle in /app/oracle/product/8.0.3
8.0.3.0.0            ORACLE Common RDBMS Libraries and Utilities
8.0.3.0.0            ORACLE PL/SQL Libraries
8.0.3.0.0            ORACLE Common Precomp Libraries
8.0.3.0.0            PL/SQL
8.0.3.0.0            Oracle8 Server (RDBMS)

Found header files in rdbms/include rdbms/demo.
Found /app/oracle/product/8.0.3/rdbms/demo/demo_rdbms.mk
Found /app/oracle/product/8.0.3/otrace/demo/atmoci.mk
Using /app/oracle/product/8.0.3/rdbms/demo/demo_rdbms.mk
Reading /app/oracle/product/8.0.3/rdbms/demo/demo_rdbms.mk.
Reading /app/oracle/product/8.0.3/rdbms/lib/env_rdbms.mk.
Deleting ORA_NLS = $(ORACLE_HOME)/ocommon/nls/admin/data/
  because it is not already set in the environment
  and it can cause ORA-01019 errors.
Deleting ORA_NLS33 = $(ORACLE_HOME)/ocommon/nls/admin/data/
  because it is not already set in the environment
  and it can cause ORA-01019 errors.
Evaluating `cat $(LIBHOME)naldflgs`
  expanded `cat /app/oracle/product/8.0.3/lib/naldflgs`
  returned ''
Evaluating `cat $(LIBHOME)sysliblist`
  expanded `cat /app/oracle/product/8.0.3/lib/sysliblist`
  returned '-lnsl -lsocket -lgen -ldl'

Attempting to discover Oracle OCI build rules...
gcc -c  -I/app/oracle/product/8.0.3/rdbms/demo -
I/app/oracle/product/8.0.3/rdbms/public -
I/app/oracle/product/8.0.3/plsql/public -
I/app/oracle/product/8.0.3/network/public -
I/app/oracle/product/8.0.3/rdbms/demo -
I/app/oracle/product/8.0.3/rdbms/include -
I/app/oracle/product/8.0.3/rdbms/demo -
I/share/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/auto/DBI -fno-strict-
aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O   -DVERSION=\"1.12\" -
DXS_VERSION=\"1.12\" -fPIC "-I/share/usr/local/lib/perl5/5.8.0/sun4-
solaris/CORE"   DBD_ORA_OBJ.c
Oracle oci build command:
        true echo -L/app/oracle/product/8.0.3/lib/ -
L/app/oracle/product/8.0.3/rdbms/lib -o DBD_ORA_EXE DBD_ORA_OBJ.o -
lclntsh /app/oracle/product/8.0.3/lib/nautab.o /app/oracle/product/8.0.3/lib/nae
et.o /app/oracle/product/8.0.3/lib/naect.o /app/oracle/product/8.0.3/lib/naedhs.
o `cat /app/oracle/product/8.0.3/lib/naldflgs` -lnetv2 -lnttcp -lnetwork -
lncr  -lnetv2 -lnttcp -lnetwork -lclient -lcommon -lgeneric -lmm -lnlsrtl3  -
lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr  -lnetv2 -
lnttcp -lnetwork -lclient -lcommon -lgeneric  -lepc -lnlsrtl3  -lcore4 -
lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lcommon -lgeneric -lnlsrtl3  -lcore4 -
lnlsrtl3 -lcore4 -lnlsrtl3   `cat /app/oracle/product/8.0.3/lib/sysliblist` -
R /opt/SUNWcluster/lib:/app/oracle/product/8.0.3/lib -Y 
P,/usr/dt/lib:/app/GCG/gcgbin/oblib:/share/usr/local/btk/CurrentRelease/lib:/app
/oracle/product/8.0.3/lib:/share/usr/local/lib/:/usr/lib:/lib:/opt/SUNWcluster/l
ib:/usr/ccs/lib:/usr/lib -Qy -lc -laio -lm  -lthread


System: perl5.008 sunos pauling 5.8 generic_108528-13 sun4u sparc sunw,ultra-250
Compiler:   gcc -O -fno-strict-aliasing -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64
Linker:     /usr/ccs/bin/ld
Sysliblist: -lnsl -lsocket -lgen -ldl
Oracle makefiles would have used these definitions but we override them:
  CC:       cc

  CFLAGS:   $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(QACCFLAGS) $(PFLAGS)\
        $(SHARED_CFLAG) $(USRFLAGS)
           [$(GFLAG) -xO2 $(CDEBUG) -Xa $(PROFILE) -xstrconst -xF $(XS) -mr -
xarch=v8 -xcache=16/32/1:1024/64/1 -xchip=ultra -D_REENTRANT -K PIC 
$(QACCFLAGS) -I/app/oracle/product/8.0.3/rdbms/demo -
I/app/oracle/product/8.0.3/rdbms/public -
I/app/oracle/product/8.0.3/plsql/public -
I/app/oracle/product/8.0.3/network/public -DSLMXMX_ENABLE -DSLTS_ENABLE -
D_SVID_GETTOD $(LPFLAGS) $(USRFLAGS)]

  LDFLAGS:  -L$(LIBHOME) -L$(ORACLE_HOME)/rdbms/lib
           [-L$(LIBHOME) -L/app/oracle/product/8.0.3/rdbms/lib]


Linking with OTHERLDFLAGS = -L/app/oracle/product/8.0.3/lib/ -
L/app/oracle/product/8.0.3/rdbms/lib   -
lclntsh /app/oracle/product/8.0.3/lib/nautab.o /app/oracle/product/8.0.3/lib/nae
et.o /app/oracle/product/8.0.3/lib/naect.o /app/oracle/product/8.0.3/lib/naedhs.
o `cat /app/oracle/product/8.0.3/lib/naldflgs` -lnetv2 -lnttcp -lnetwork -
lncr  -lnetv2 -lnttcp -lnetwork -lclient -lcommon -lgeneric -lmm -lnlsrtl3  -
lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 -lnetv2 -lnttcp -lnetwork -lncr  -lnetv2 -
lnttcp -lnetwork -lclient -lcommon -lgeneric  -lepc -lnlsrtl3  -lcore4 -
lnlsrtl3 -lcore4 -lnlsrtl3 -lclient -lcommon -lgeneric -lnlsrtl3  -lcore4 -
lnlsrtl3 -lcore4 -lnlsrtl3   `cat /app/oracle/product/8.0.3/lib/sysliblist` -
R/opt/SUNWcluster/lib:/app/oracle/product/8.0.3/lib -
YP,/usr/dt/lib:/app/GCG/gcgbin/oblib:/share/usr/local/btk/CurrentRelease/lib:/ap
p/oracle/product/8.0.3/lib:/share/usr/local/lib/:/usr/lib:/lib:/opt/SUNWcluster/
lib:/usr/ccs/lib:/usr/lib -Qy -lc -laio -lm  -lthread [from 'build' rule]


LD_RUN_PATH=/app/oracle/product/8.0.3/lib:/app/oracle/product/8.0.3/rdbms/lib
Using DBD::Oracle 1.12.
Using DBD::Oracle 1.12.
Using DBI 1.32 installed in /share/usr/local/lib/perl5/site_perl/5.8.0/sun4-
solaris/auto/DBI
Writing Makefile for DBD::Oracle

***  If you have problems...
     read all the log printed above, and the README and README.help files.
     (Of course, you have read README by now anyway, haven't you?)
--------------------------

>perl -V
Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration:
  Platform:
    osname=solaris, osvers=2.8, archname=sun4-solaris
    uname='sunos foo 5.8 generic_108528-13 sun4u sparc sunw,ultra-250 '
    config_args=''
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef 
usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=undef use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='gcc', ccflags ='-fno-strict-aliasing -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64',
    optimize='-O',
    cppflags='-fno-strict-aliasing'
    ccversion='', gccversion='3.2', gccosandvers='solaris2.8'
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', 
lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='gcc', ldflags =' -L/usr/local/lib '
    libpth=/usr/local/lib /usr/lib /usr/ccs/lib
    libs=-lsocket -lnsl -lgdbm -ldb -ldl -lm -lc
    perllibs=-lsocket -lnsl -ldl -lm -lc
    libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
    cccdlflags='-fPIC', lddlflags='-G -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Compile-time options: USE_LARGE_FILES
  Built under solaris
  Compiled at Dec 11 2002 14:42:03
  @INC:
    /share/usr/local/lib/perl5/5.8.0/sun4-solaris
    /share/usr/local/lib/perl5/5.8.0
    /share/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris
    /share/usr/local/lib/perl5/site_perl/5.8.0
    /share/usr/local/lib/perl5/site_perl/5.6.0
    /share/usr/local/lib/perl5/site_perl
----------------
>gcc -v
Reading specs from /share/usr/local/bin/../lib/gcc-lib/sparc-sun-
solaris2.8/3.2/specs
Configured with: ../configure --with-as=/usr/ccs/bin/as --with-
ld=/usr/ccs/bin/ld --disable-nls
Thread model: posix
gcc version 3.2
0
a314159
1/13/2003 7:44:19 PM
perl.dbi.users 11098 articles. 1 followers. Follow

0 Replies
1092 Views

Similar Articles

[PageSpeed] 25

Reply:

Similar Artilces:

[PATCH oci8.c] Compile DBD-Oracle-1.12 on Solaris 8 with Oracle 8.0.5
I don't know if this is useful to anyone, but here it is. This will help DBD::Oracle version 1.12 compile on Solaris 8 with Oracle 8.0.5. - D <dmlloyd@tds.net> ---------- Forwarded message ---------- Date: Thu, 6 Sep 2001 13:55:09 -0500 (CDT) From: David Lloyd <usrodl@ohno.workpc.tds.net> --- oci8.c.orig Thu Sep 6 13:53:34 2001 +++ oci8.c Thu Sep 6 13:54:08 2001 @@ -97,7 +97,9 @@ case OCI_HTYPE_TRANS: return "OCI_HTYPE_TRANS"; case OCI_HTYPE_COMPLEXOBJECT: return "OCI_HTYPE_COMPLEXOBJECT"; case OCI_HT...

Compile problems: Solaris 8, DBD-Oracle1.14, Oracle 9.2.0.1.0, Pe rl 5.8.0
> I ran into this same problem while trying to do a "make" while installing > DBD::Oracle 1.14 on Solaris 8 (64-bit) with Oracle 9.2.0.3.0 and Perl 5.8. > After seeing "ld: warning: option -o appears more than once, first setting > taken", I decided to try and delete all instances of "-o build" from the > Makefile so that I'd be left with just a "-o > blib/arch/auto/DBD/Oracle/Oracle.so" since Oracle.so was the file that it > seemed to be looking for. This allowed me to finish the make and go on > to successfully make...

DBD-Oracle 1.12 install problem with Oracle 8.0.5.0 EE
Hi folks, I just tried the new DBD-Oracle 1.12 under SuSE Linux 7.2 (2.2.19/glibc 2.2.2). It wouldn't build because of two undefined symbols. I had to comment OCI_HTYPE_SUBSCRIPTION and OCI_DTYPE_LOCATOR out. After that it build and tests worked ok. Here is the output of 'perl Makefile.PL -v' Using DBI 1.20 installed in /usr/lib/perl5/site_perl/5.6.0/i586-linux/auto/DBI Configuring DBD::Oracle ... >>> Remember to actually *READ* the README file! Especially if you have any problems. Using Oracle in /opt/oracle 4.0.3.0.0 Oracle Unix Ins...

DBD-Oracle-1.12 under cygwin with Oracle 8.1.5.0.0?
Hi, I try to compile DBD-Orcacle-1.12 under cygwin, (installed on Windows NT), but... I made libic.a, and put it into /usr/local/lib/ dir, I installed Oracle client products (Pro*C/C++, OCI version 8.1.5.0.0), but I can't compile it... Could anybody help me? Thanks a lot, and sorry for my poor english, Endre --------- screen capture start: --------------------- zelenae@ZELENAE ~/src/DBD-Oracle-1.12 $ export ORACLE_HOME="/cygdrive/e/Oracle815/" zelenae@ZELENAE ~/src/DBD-Oracle-1.12 $ perl Makefile.PL Using DBI 1.32 installed in /usr/lib/perl5/site_perl/5...

Problem compiling/installing DBD::Oracle 1.12 on Solaris 8 / Oracle 9.2.0.1 (ORA-03106)
I've been trying to get DBD::Oracle 1.12 working on Solaris 8, with perl 5.8.0, DBI 1.30, and Oracle 9.2.0.1 Unfortunately, the 'make test' is failing, and even if I ignore that, the same problems show up when I try to run scripts that work fine on an older environment, namely, the fetch statements return ORA-03106: fatal two-task communication protocol error (DBD ERROR: OCIStmtFetch). Also, the 'make test' routine hangs at test 55 of the plsql tests. In order to get it to compile, with the 64 bit error, I had to change all the $ORACLE_HOME/lib and $ORA...

Problems with DBD-Oracle 1.07 and Oracle 8.1.6.0.0 under Windows2000
------=_NextPart_000_0013_01C10878.32D67DE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hallo there, I've identified a problem with the DBD-Oracle 1.07 (the same problem occurs with DBD-Oracle 1.06) and the Oracle 8.1.6.0.0 client libraries connected to a 8.1.7.0.0 database. Under Windows 2000, the process crashes with a general exception error (0xC0000005, access violation) while processing the prepare method of a instantiated dbi object, when the processed statement contains a field in the select list like: $stmt = " ...

Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
Greetings, we do have one big trouble with the following (rare?) combination: Solaris 2.8/Intel Oracle 8.1.5 (delivered with Solaris as evaluation version) DBD::Oracle 1.08 Perl 5.6.1 (no-threads) The problem is that nothihg does work. Namely, we already gave up trying to get server running and now we are trying to set-up Oracle client + DBI to access the database running on another Solaris/SPARC box. The point is that connection from perl script failes whereas the connection with SQLPLUS works OK. Surely the username/password and instance names are the same. The error messa...

Patch to DBD-Oracle-1.12 to compile with Oracle 8.0.3
The appended patch shows the (trivial) changes I had to make to get DBD-Oracle-1.12 compile with Oracle 8.0.3. David Hull --- oci8.c 2001/09/26 02:18:55 1.1 +++ oci8.c 2001/10/10 18:58:47 1.2 @@ -1,5 +1,5 @@ /* - $Id: oci8.c,v 1.1 2001/09/26 02:18:55 hull Exp $ + $Id: oci8.c,v 1.2 2001/10/10 18:58:47 hull Exp $ Copyright (c) 1998,1999,2000,2001 Tim Bunce @@ -97,7 +97,9 @@ case OCI_HTYPE_TRANS: return "OCI_HTYPE_TRANS"; case OCI_HTYPE_COMPLEXOBJECT: return "OCI_HTYPE_COMPLEXOBJECT"; case OCI_HTYPE_SECURITY: ...

DBD-Oracle 1.12 installation failure with Oracle 8.0.5
Hello Tim, When I was trying to install DBD-Oracle module on our box with Oracle = 8.0.5 , I was unable to go through "make" step of the installation of = the module. Here is the last part of log: ----------------- cc -c -I/usr/oracle/product/8.0.5/rdbms/demo = -I/usr/oracle/product/8.0.5/rdbms/public = -/usr/oracle/product/8.0.5/plsql/public = -I/usr/oracle/product/8.0.5/network/public = -I/usr/oracle/product/8.0.5/rdbms/demo = -I/usr/oracle/product/8.0.5/rdbms/demo = -I/usr/banner/perl/lib/site/alpha-dec_osf/auto/DBI -std -fprm d -ieee = -D_INTRINSICS -DLANGUAGE_C -O4 ...

EAServer 5.3.0, Oracle 8.1.7 Database with Oracle 10.1.0.2 client VARCHAR2(4000) problem
Hello! I'm having some problems in this configuration on Windows XP. I am developing websites on an Oracle database (8.1.7), with EAServer 5.3.0 (build 53016), Java objects using JSP as a front end. Here is my problem, I have a table with 2 VARCHAR2(4000), and when I access the webpage, the they are displayed as '?????????????'. If I debug the PB component, when I affect the DW field to a variable, it displays it as it doesn't "understand" a thing (each character is replaced by a square). The codeset of EAServer is UTF8, and on my client, it is AM...

Make error: DBD-Oracle-1.14 , DBI-1.39, Oracle rdbms 9.2.0.0.0 , solaris 9
------=_NextPart_000_0025_01C3BE5A.4F6A0C70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, When I make DBD-Oracle 1.14 , Makefile.PL generates a Makefile with "-o build" in the compiler string before blib/arch/auto/DBD/Oracle/Oracle.so and prevents Oracle.so from being built correctly. demo_rdbms.mk appears to be to supplying this: Attempting to discover Oracle OCI build rules^M gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c^M by executing: (make -f /export/home/oracle/ora9idbms/rdbms/demo/demo_rdbms.mk bu ild ECHODO=echo EC...

Re: DBD::Oracle doesn't work with Oracle 10g (10.1.0.3) under Mac OS X (10.3.8) or how to make it working?
Hermez, et al, On Apr 9, 2005, Hermez <4Hertz@gmx.de> wrote: > After painful days and nights, trying to make DBD::Oracle working > with Oracle 10g Release 1 (10.1.0.3) on Mac OS X, I am at my wits' > end. > I have started the hard trip with the Oracle instant client and even > the above mentioned full version doesn't lead to a solution. > Afterwards, I have followed the advice mentioned in README.macosx > (included in DBD::Oracle), and installed Perl from scratch. Without > progress, unfortunately. > Let me describe the affected envir...

Oracle 8.1.7, Solaris 8 Intel, DBD::Oracle 1.07
I am new to the group, but I am actually subscribing to post a solution, rather than ask a question (go figure) As it seems that if you ask what is considered to be a stupid question, you either get flamed pretty bad, or a message saying RTFM. My problem related to the core dumps during the "make test" for DBD:Oracle 1.07 I saw a million and one posts just like mine (with stack traces, and -v output), but no solution was offered. Then one day, I ran into a message posted by John E. Leon Guerrero titled "solaris 8 intel, oracle 8.1.6, successful install!!!" T...

DBD::Oracle-1.12, Tru64 UNIX V5.0, Oracle8 8.0.6.0.0
------=_NextPart_000_0082_01C1C526.5637EF60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit When installing, I try the tests and they fail with the following error: Failed to load Oracle extension and/or shared libraries: install_driver(Oracle) failed: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: dlopen: cannot load blib/arch/auto/DBD/Oracle/Oracle.so at /usr/local/lib/perl 5/5.6.1/alpha-dec_osf/DynaLoader.pm line 206. at (eval 1) line 3 I've tried 'perl Makefile.PL -nob' and 'p...

PowerBuilder Oracle Driver for Oracle 8.0.4 and 8.0.5
You may now register for the beta program for the PowerBuilder O84 native driver at the following URL http://www.sybase.com/products/powerbuilder/oracle/oracle_reg.html Has anyone been using this? Any comments? On Mon, 14 Dec 1998 11:32:31 -0500, in powersoft.public.powerbuilder.database Dan Skibba <skibba@sybase.com> wrote: >You may now register for the beta program for the PowerBuilder O84 native >driver at the following URL >http://www.sybase.com/products/powerbuilder/oracle/oracle_reg.html > > One of the things you do when you sign up for a beta ...

Web resources about - DBD::Oracle (perl 5.8.0, Oracle 8.0.3, DBD-Oracle 1.12, Solaris 8) make problems (fprintf) - perl.dbi.users

Resources last updated: 12/19/2015 4:42:36 PM