subject:"RE\: DBD error"

RE: DBD error

2020-07-21 Thread Kevin Moore

Hi Bala,

 

I’d show this to my sys admin, looks like there are missing libraries on your 
system.

 

Cheers 

 

From: Bala GANESH  
Sent: Tuesday, July 21, 2020 3:18 AM
To: Kevin Moore 
Cc: Christopher Jones ; dbi-users@perl.org
Subject: Re: DBD error

 

HI Kevin, 

 

While DB:Oracle , am facing below error , based on your availability tell me 
the free time , am ready to share my screen 

 

[root@vm-postgresql DBD-Oracle-1.75_2]# make
"/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- Oracle.bs 
blib/arch/auto/DBD/Oracle/Oracle.bs 644
rm -f blib/arch/auto/DBD/Oracle/Oracle.so
gcc  -lpthread -shared -Wl,-z,relro -Wl,-z,now 
-specs=/usr/lib/rpm/redhat/redhat-hardened-ld -L/usr/local/lib 
-fstack-protector-strong  Oracle.o dbdimp.o oci8.o  -o 
blib/arch/auto/DBD/Oracle/Oracle.so  \
   -L/opt/oracle/product/12.1.0/client_1/lib -lclntsh -ldl -lm -lpthread -lnsl 
-lirc -limf -lirc -lrt -laio -lresolv -lsvml -lperl   \

/usr/bin/ld: cannot find -lnsl
/usr/bin/ld: cannot find -laio
collect2: error: ld returned 1 exit status
make: *** [Makefile:524: blib/arch/auto/DBD/Oracle/Oracle.so] Error 1

 

 

 

On Mon, Jul 20, 2020 at 7:35 PM Kevin Moore mailto:kmo...@esntech.com> > wrote:

If you’re using an 11.2.0.4 client and that versions libraries, you may want to 
upgrade the client to something more current because I’m not sure this client 
is supported by Oracle.  Here is what was posted that makes me believe that way:

 

ld: 0711-736 ERROR: Input file /oracle/product/11.2.0.4/lib/libclntsh.so 
<https://urldefense.com/v3/__http:/11.2.0.4/lib/libclntsh.so__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXh-SIBnPA$>
 :

 

 

From: Christopher Jones mailto:christopher.jo...@oracle.com> > 
Sent: Sunday, July 19, 2020 4:38 PM
To: dbi-users@perl.org <mailto:dbi-users@perl.org> ; bala_gan...@carrefour.com 
<mailto:bala_gan...@carrefour.com> 
Subject: Re: DBD error

 

 

On 17/7/20 10:02 pm, Bala GANESH wrote:

Hi Support,

"Support" ? :)

 
 
I am receiving following error while installing DBD Perl module on IBM AIX 7.1 
.Please help me to solve this..
 
bash-3.2# perl Makefile.PL 
 
*
ld: 0711-736 ERROR: Input file /oracle/product/11.2.0.4/lib/libclntsh.so 
<https://urldefense.com/v3/__http:/11.2.0.4/lib/libclntsh.so__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXh-SIBnPA$>
 :
XCOFF64 object files are not allowed in 32-bit mode.
make: 1254-004 The error code from the last command is 8.
*
 
pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# export 
ORACLE_HOME=/oracle/product/19.7/
pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# export 
LD_LIBRARY_PATH=/oracle/product/19.7/lib
pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# perl Makefile.PL
Using DBI 1.643 (for perl 5.028001 on aix-thread-multi) installed in 
/usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/
Configuring DBD::Oracle for perl 5.028001 on aix (aix-thread-multi)
 
If you encounter any problem, a collection of troubleshooting
guides are available under lib/DBD/Oracle/Troubleshooting.
'DBD::Oracle::Troubleshooting' is the general troubleshooting
guide, while platform-specific troubleshooting hints
live in their labelled sub-document (e.g., Win32
hints are gathered in 'lib/DBD/Oracle/Troubleshooting/Win32.pod').
 
Installing on a aix, Ver#7.1
Using Oracle in /oracle/product/19.7
DEFINE _SQLPLUS_RELEASE = "190700" (CHAR)
Oracle Version 19.7.0.0 (19.7)
Found direct-link candidates: libclntsh.a libclntsh.so
Oracle sysliblist: /lib/crt0_64.o -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld 
-lperfstat
Found header files in /oracle/product/19.7/rdbms/public.
Your LIBPATH env var is set to ''
WARNING: Your LIBPATH env var doesn't include '/oracle/product/19.7/lib' but 
probably needs to.

 

Did you try setting LIBPATH instead of LD_LIBRARY_PATH?  
https://www.ibm.com/support/pages/libpath-environment-variables-aix-platforms 
<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.ibm.com_support_pages_libpath-2Denvironment-2Dvariables-2Daix-2Dplatforms=DwMFaQ=oYSInPoxeTs4m10ilnGu9Q=epNtSOT0Nv3ejsgXp-J4jOmfo8HlYyawp_IXKa881cY=6ifBm5aRmkE9Ys1nxaSfQ_qUlmJZ7osJjwXqYzzV2Fo=eahDz0l4E-ozVHu3LelqHyh6OVOY6waGt9afuyWYQ2g=>
 

Chris

 

 
client_version=19.7
 
 
DEFINE= -DUTF8_SUPPORT -DORA_OCI_VERSION=\"19.7.0.0\" -DORA_OCI_102 
-DORA_OCI_112
 
 
Checking for functioning wait.ph 
<https://urldefense.com/v3/__http:/wait.ph__;!!GqivPVa7Brio!NM_RUNr17m8XiY2tlidQ7CJSsGke0KkpeXoQjgBTUcuGoEIvGufbgnpJofI6kXjwPaqgsA$>
 
 
 
System: perl5.028001 aix fvt-p7a2-lp2 1 7 668a7a00
Compil

Re: DBD error

2020-07-20 Thread John D Groenveld

In message 
, Bala GANESH writes:
>ld: 0711-736 ERROR: Input file /oracle/product/19.7/lib/libclntsh.so:
>XCOFF64 object files are not allowed in 32-bit mode.


$ file `which perl`

$ file /oracle/product/19.7/lib/libclntsh.so

John
groenv...@acm.org

Re: DBD error

2020-07-20 Thread Martin J. Evans


On 17/07/2020 13:02, Bala GANESH wrote:


        
LD_RUN_PATH="/oracle/product/19.7/lib:/oracle/product/19.7/rdbms/lib" 
ld  -bhalt:4 -G 
-bI:/usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE/perl.exp 
 -bnoentry -lpthreads -lc -lm -bE:Oracle.exp Oracle.o  dbdimp.o 
 oci8.o  -o blib/arch/auto/DBD/Oracle/Oracle.so   
 -L/oracle/product/19.7/lib -lclntsh -ldl -lc -lm -lpthreads -lodm 
-lbsd_r -lld -lperfstat ld: 0711-736 ERROR: Input file 
/oracle/product/19.7/lib/libclntsh.so:         XCOFF64 object files 
are not allowed in 32-bit mode. make: 1254-004 The error code from the 
last command is 8. Stop. 
pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# make 
install          "/usr/bin/perl" -MExtUtils::Command::MM -e 
'cp_nonempty' -- Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs 644     
    rm -f blib/arch/auto/DBD/Oracle/Oracle.so         
LD_RUN_PATH="/oracle/product/19.7/lib:/oracle/product/19.7/rdbms/lib" 
ld  -bhalt:4 -G 
-bI:/usr/opt/perl5/lib/5.28.1/aix-thread-multi/CORE/perl.exp 
 -bnoentry -lpthreads -lc -lm -bE:Oracle.exp Oracle.o  dbdimp.o 
 oci8.o  -o blib/arch/auto/DBD/Oracle/Oracle.so   
 -L/oracle/product/19.7/lib -lclntsh -ldl -lc -lm -lpthreads -lodm 
-lbsd_r -lld -lperfstat ld: 0711-736 ERROR: Input file 
/oracle/product/19.7/lib/libclntsh.so:         XCOFF64 object files 
are not allowed in 32-bit mode. make: 1254-004 The error code from the 
last command is 8. Stop.


I'd guess you are not using the same C compiler to build DBD::Oracle 
that was used to build Perl. Did you build Perl or did you get it 
pre-built from a repository for AIX? If the latter then you need to use 
the same compiler as was used to build Perl. You are mixing 32 bit 
compiled code with 64 bit compiled code as it stands.


Martin

--
Martin J. Evans
Wetherby, UK

Re: DBD error

2020-07-19 Thread Christopher Jones



On 17/7/20 10:02 pm, Bala GANESH wrote:

Hi Support,


"Support" ? :)


I am receiving following error while installing DBD Perl module on IBM AIX 7.1 
.Please help me to solve this.. bash-3.2# perl Makefile.PL
* ld: 
0711-736 ERROR: Input file /oracle/product/11.2.0.4/lib/libclntsh.so 
: 
        XCOFF64 object files are not allowed in 32-bit mode. make: 1254-004 The error code from the last command is 8. 
* 
pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# export ORACLE_HOME=/oracle/product/19.7/ 
pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# export LD_LIBRARY_PATH=/oracle/product/19.7/lib 
pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# perl Makefile.PL Using DBI 1.643 (for perl 5.028001 on aix-thread-multi) installed in 
/usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/ Configuring DBD::Oracle for perl 5.028001 on aix (aix-thread-multi) If you encounter 
any problem, a collection of troubleshooting guides are available under lib/DBD/Oracle/Troubleshooting. 'DBD::Oracle::Troubleshooting' is the 
general troubleshooting guide, while platform-specific troubleshooting hints live in their labelled sub-document (e.g., Win32 hints are gathered in 
'lib/DBD/Oracle/Troubleshooting/Win32.pod'). Installing on a aix, Ver#7.1 Using Oracle in /oracle/product/19.7 DEFINE _SQLPLUS_RELEASE = 
"190700" (CHAR) Oracle Version 19.7.0.0 (19.7) Found direct-link candidates: libclntsh.a libclntsh.so Oracle sysliblist: /lib/crt0_64.o -ldl -lc 
-lm -lpthreads -lodm -lbsd_r -lld -lperfstat Found header files in /oracle/product/19.7/rdbms/public. Your LIBPATH env var is set to '' WARNING: 
Your LIBPATH env var doesn't include '/oracle/product/19.7/lib' but probably needs to.


Did you try setting LIBPATH instead of LD_LIBRARY_PATH? 
https://www.ibm.com/support/pages/libpath-environment-variables-aix-platforms

Chris


client_version=19.7 DEFINE= -DUTF8_SUPPORT -DORA_OCI_VERSION=\"19.7.0.0\" -DORA_OCI_102 -DORA_OCI_112 Checking for functioning wait.ph 
 System: 
perl5.028001 aix fvt-p7a2-lp2 1 7 668a7a00 Compiler:   xlc_r -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=-1 -qnoansialias 
-qlanglvl=extc99 -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT -q32 -D_LARGE_FILES Linker:     /usr/bin/ld Sysliblist: /lib/crt0_64.o -ldl -lc -lm 
-lpthreads -lodm -lbsd_r -lld -lperfstat Linking with -lclntsh. Unrecognized argument in LIBS ignored: '/lib/crt0_64.o' 
LD_RUN_PATH=/oracle/product/19.7/lib:/oracle/product/19.7/rdbms/lib Using DBD::Oracle 1.80. Using DBD::Oracle 1.80. Using DBI 1.643 (for perl 
5.028001 on aix-thread-multi) installed in /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/ Generating a Unix-style Makefile Writing 
Makefile for DBD::Oracle Writing MYMETA.yml and MYMETA.json pibdev:root[/oracle/PIBDEV2/post/softwares/DBD-Oracle-1.80]# make Skip 
blib/arch/auto/DBD/Oracle/dbdimp.h (unchanged) Skip blib/arch/auto/DBD/Oracle/Oracle.h (unchanged) Skip 
blib/lib/DBD/Oracle/Troubleshooting/Linux.pod (unchanged) cp mk.pm 
 
blib/arch/auto/DBD/Oracle/mk.pm 
 Skip 
blib/lib/DBD/Oracle/Troubleshooting/Sun.pod (unchanged) Skip blib/lib/DBD/Oracle/Troubleshooting/Aix.pod (unchanged) Skip 
blib/lib/DBD/Oracle/Troubleshooting/Vms.pod (unchanged) Skip blib/lib/DBD/Oracle/GetInfo.pm (unchanged) Skip 
blib/lib/DBD/Oracle/Troubleshooting/Hpux.pod (unchanged) Skip blib/lib/DBD/Oracle/Troubleshooting/Cygwin.pod (unchanged) Skip 
blib/lib/DBD/Oracle/Troubleshooting/Win32.pod (unchanged) Skip blib/lib/DBD/Oracle/Troubleshooting/Macos.pod (unchanged) Skip 
blib/lib/DBD/Oracle/Troubleshooting.pod (unchanged) Skip blib/lib/DBD/Oracle.pm (unchanged) Skip blib/lib/DBD/Oracle/Object.pm (unchanged) Skip 
blib/lib/DBD/Oracle/Troubleshooting/Win64.pod (unchanged) Skip blib/arch/auto/DBD/Oracle/ocitrace.h (unchanged) Running Mkbootstrap for Oracle ()   
      chmod 644 "Oracle.bs"          "/usr/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs 644   
      xlc_r -c  -I/oracle/product/19.7/rdbms/public -I/usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI  -D_ALL_SOURCE -D_ANSI_C_SOURCE 
-D_POSIX_SOURCE

RE: DBD error

2013-05-23 Thread Anoop Kumar Paramesweran

After researching I could find this ,, But issue is that with 11gR2 onwards 
lib32 is not installing by default so need to install and configure seperatly 
its very difficuilt task for DBA..

Is DBD 64bit is available??

The problem looks like Perl and DBI run in 32-bit mode, but Oracle 9i
installs
as
64-bit.  (Oracle 8 installed as 32-bit.)  I saved the following email
with the
solution
in my bag of tricks.  This message was for Solaris, which is what I am
using.
A
week or so ago, it also worked for hpux.  Hopefully it will work for you
on
AIX.
=
Our solution: bit-time-kludge
afer Makefile.PL creates the makefile, edit it in vi.
Replace '911/lib' with '911/lib32' everywhere
Replace 'rdbms/lib' with 'rdbms/lib32' everywhere.
Then do your make.
To really fix this will take someone who knows Makefile.PL to apply a
patch
detect the 64bit version of Oracle9i(the presense of lib32's is a tip
off).
In the mean time we applied a quick script to do it in our
install/distribution scripts.




Anoop Kumar Paramesweran | Expert - Unix and Storage Systems




e anoop.ku...@nawras.om | m +96895103659
twitter/nawras_oman | facebook/nawras



[cid:image001.gif@01CE57DA.91D73410]




[cid:image002.gif@01CE57DA.91D73410]


From: Anoop Kumar Paramesweran
Sent: Thursday, May 23, 2013 4:25 PM
To: 'dbi-users@perl.org'
Subject: DBD error

Hi Support,

I am receiving following error while installing DBD Perl module on IBM AIX 7.1 
.Please help me to solve this..

bash-3.2# perl Makefile.PL
Using DBI 1.625 (for perl 5.010001 on aix-thread-multi) installed in 
/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI/

Configuring DBD::Oracle for perl 5.010001 on aix (aix-thread-multi)

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

Installing on a aix, Ver#5.3
Using Oracle in /u01/app/oracle/product/11.2.0/dbhome_1
DEFINE _SQLPLUS_RELEASE = 1102000300 (CHAR)
Oracle version 11.2.0.3 (11.2)
Found /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Using /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Your LIBPATH env var is set to '/u01/app/oracle/product/11.2.0/dbhome_1/lib'
Reading /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk
Reading /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/env_rdbms.mk
Deleting -b64 from COMPOBJS because -b64 doesn't exist.
WARNING: Oracle /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ins_rdbms.mk 
doesn't define a 'build' rule.

WARNING: I will now try to guess how to build and link DBD::Oracle for you.
 This kind of guess work is very error prone and Oracle-version 
sensitive.
 It is possible that it won't be supported in future versions of 
DBD::Oracle.
 *PLEASE* notify dbi-users about exactly _why_ you had to build it this 
way.

Found header files in /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public.

client_version=11.2


DEFINE= -DUTF8_SUPPORT -DORA_OCI_VERSION=\11.2.0.3\ -DORA_OCI_102 
-DORA_OCI_112


Checking for functioning wait.ph


System: perl5.010001 aix dennis01 3 5 00c72e9a4c00
Compiler:   xlc_r -q32 -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE 
-qmaxmem=-1 -qnoansialias -DUSE_NATIVE_DLOPEN -DNEED_PTHREAD_INIT 
-qlanglvl=extended -I/usr/local/include -q32 -D_LARGE_FILES -qlonglong
Linker: /usr/bin/ld
Sysliblist: /lib/crt0_64.o -ldl -lc -lm -lpthreads -lodm -lbsd_r -lld -lperfstat
Oracle makefiles would have used these definitions but we override them:
  CC:   $(ORACLE_HOME)/bin/oraxlc $(ORAXLCFLAGS)
  CFLAGS:   $(GFLAG) $(OPTIMIZE) $(CDEBUG) $(CCFLAGS) $(PFLAGS)\
$(SHARED_CFLAG) $(USRFLAGS)
   [$(GFLAG) -O3 $(CDEBUG) -q64 -DSS_64BIT_SERVER -qwarn64 -qinfo=uni 
-DAIXRIOS -qflag=s:s -I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/demo 
-I/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/public 
-I/u01/app/oracle/product/11.2.0/dbhome_1/plsql/public 
-I/u01/app/oracle/product/11.2.0/dbhome_1/network/public -DLDAP_CM $(LPFLAGS) 
$(PLSQLNCGFLAGS) $(USRFLAGS)]
  LDFLAGS:  -o $@ $(LDPATHFLAG)$(PRODLIBHOME) $(LDPATHFLAG)$(LIBHOME)
   [-o $@ -L/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ 
-L$(LIBHOME)]
Linking with /lib/crt0_64.o -lclntsh -brtl -lld -lm  -ldl -lc -lm -lpthreads 
-lodm -lbsd_r -lld -lperfstat -lm -lpthreads [from $(OCISHAREDLIBS)]


WARNING: You will may need to rebuild perl using the xlc_r compiler.
 The important thing is that perl and DBD::Oracle be built with the 
same compiler.
 You may also need to: ORACCENV='cc=xlc_r'; export ORACCENV
 Also see README.aix for gcc instructions and read about the -p option.
Unrecognized argument in LIBS ignored: '-brtl'
LD_RUN_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib:/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/lib
Using DBD::Oracle 1.62.
Using DBD::Oracle 1.62.
Using DBI 1.625 (for perl 5.010001 on aix-thread-multi) installed in 
/usr/opt/perl5/lib/site_perl/5.10.1/aix-thread-multi/auto/DBI/
Writing Makefile

Re: DBD ERROR: LOB refetch attempted for unsupported statement type

2011-09-03 Thread Martin J. Evans


On 03/09/2011 07:50, Shobha Deepthi V (sobv) wrote:

Hi,



  I am calling a stored procedure that returns ref cursor from perl. But
it fails with the following error,



DBD::Oracle::st execute failed:  ( DBD ERROR: LOB refetch attempted for
unsupported statement type )



I searched for this error, and all the results show how to read a CLOB
return type but not a ref cursor. Any help is much appreciated.

Here's my perl code,



sub run_proc{

...

...

...

 $sth-bind_param_inout(:p1, \$args-[0],length($args-[0]), {
ora_type =  ORA_CLOB});

 $sth-bind_param_inout(:p2, \$args-[1],length($args-[1]));

 $sth-bind_param_inout(:p3, \$args-[2],1);

 $sth-bind_param_inout(:p4, \$res,0,{ ora_type =  ORA_RSET});

 $sth-execute();

 

}



And the stored procedure looks like,



PROCEDURE p_search_eol_data(

 pid_string IN CLOB,

 where_clause IN VARCHAR2,

 role_flag IN NUMBER,

 results OUT searchCursor)

 IS

 queryString LONG;

 BEGIN

 queryString := '';/* dynamic query */

   open results for queryString;

  END;







Thanks,

Shobha Deepthi V





Just some observations that might help you.

You don't need to bind the input parameters with bind_param_inout, just 
use bind_param (first 3 parameters).


Which lob are you talking about, the input lob pid_string or a lob 
returned in the reference cursor? Bind the input lob with bind_param and 
take the reference cursor out of the procedure to make sure you are 
getting the lob in first then put the reference cursor back in. The 
output reference cursor ends up creating a new DBI statement handle for 
you (your $res) and you need to bind parameters on that and call fetch. 
If one of the columns returned from the reference cursor is a lob too 
you'll need to bind it as a lob then use one of the lob fetching 
mechanisms to fetch it - personally I prefer to turn off ora_auto_lob 
and use ora_lob_length and ora_lob_read.


Martin

RE: DBD Error on test

2004-06-28 Thread Reidy, Ron

Did you:

1.  Read the README files?
2.  Ensure your Oracle environment is specified correctly (LD_LIBRARY_PATH or it's 
HP-UX equivalent, etc.)?

-
Ron Reidy
Senior DBA
Array BioPharma, Inc.


-Original Message-
From: MCMULLIN, NANCY [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28, 2004 8:07 AM
To: [EMAIL PROTECTED] Org (E-mail)
Subject: DBD Error on test


Still attempting to load DBD::Oracle  (HPUX 11i , Perl 5.8)
  
I got it past make by substituting all +s and +n's with -W1 and -Wl .  

Now test is failing with  the error (s) :
Exec format error at /opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/DynaLoader.pm line 
229.
 at (eval 1) line 3
Perhaps a required shared library or dll isn't installed where expected
 at t/base.t line 19  
 
(Perl works fine with other modules)
 
If anyone has any ideas of where to go from here, I certainly would appreciate it.  
I'm almost to the point of using Activestate and windows as the Perl Server, connected 
to the HP, since that works right now.  I hate saying that, because I hate windows 
products.  I really would like to make this work under Unix!!
 
Thanks.
Nancy 

 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBD Error on test

2004-06-28 Thread Hardy Merrill

IIRC (and that's a BIG if since I have never done this myself on HP-UX)
there is a separate DBD::Oracle README file for HP-UX.

Here is one link I found on google by searching for perl dbd::oracle
hp ux readme:

 http://perl.active-venture.com/README.hpux.html

HTH.

Hardy Merrill

 Reidy, Ron [EMAIL PROTECTED] 06/28/04 10:36AM 
Did you:

1.  Read the README files?
2.  Ensure your Oracle environment is specified correctly
(LD_LIBRARY_PATH or it's HP-UX equivalent, etc.)?

-
Ron Reidy
Senior DBA
Array BioPharma, Inc.


-Original Message-
From: MCMULLIN, NANCY [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 28, 2004 8:07 AM
To: [EMAIL PROTECTED] Org (E-mail)
Subject: DBD Error on test


Still attempting to load DBD::Oracle  (HPUX 11i , Perl 5.8)
  
I got it past make by substituting all +s and +n's with -W1 and -Wl . 


Now test is failing with  the error (s) :
Exec format error at
/opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/DynaLoader.pm line 229.
 at (eval 1) line 3
Perhaps a required shared library or dll isn't installed where
expected
 at t/base.t line 19  
 
(Perl works fine with other modules)
 
If anyone has any ideas of where to go from here, I certainly would
appreciate it.  I'm almost to the point of using Activestate and windows
as the Perl Server, connected to the HP, since that works right now.  I
hate saying that, because I hate windows products.  I really would like
to make this work under Unix!!
 
Thanks.
Nancy 

 


This electronic message transmission is a PRIVATE communication which
contains
information which may be confidential or privileged. The information is
intended 
to be for the use of the individual or entity named above. If you are
not the 
intended recipient, please be aware that any disclosure, copying,
distribution 
or use of the contents of this information is prohibited. Please notify
the
sender  of the delivery error by replying to this message, or notify us
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: DBD Error on test

2004-06-28 Thread MCMULLIN, NANCY

Ron, 

Yes, I have read the readme files about 20 times.   All paths mentioned in readme are 
set correctly.
Any other ideas?

Nancy
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28, 2004 8:36 AM
To: MCMULLIN, NANCY; [EMAIL PROTECTED] Org (E-mail)
Subject: RE: DBD Error on test


Did you:

1.  Read the README files?
2.  Ensure your Oracle environment is specified correctly (LD_LIBRARY_PATH or it's 
HP-UX equivalent, etc.)?

-
Ron Reidy
Senior DBA
Array BioPharma, Inc.


-Original Message-
From: MCMULLIN, NANCY [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28, 2004 8:07 AM
To: [EMAIL PROTECTED] Org (E-mail)
Subject: DBD Error on test


Still attempting to load DBD::Oracle  (HPUX 11i , Perl 5.8)
  
I got it past make by substituting all +s and +n's with -W1 and -Wl .  

Now test is failing with  the error (s) :
Exec format error at /opt/perl/lib/5.8.0/PA-RISC1.1-thread-multi/DynaLoader.pm line 
229.
 at (eval 1) line 3
Perhaps a required shared library or dll isn't installed where expected
 at t/base.t line 19  
 
(Perl works fine with other modules)
 
If anyone has any ideas of where to go from here, I certainly would appreciate it.  
I'm almost to the point of using Activestate and windows as the Perl Server, connected 
to the HP, since that works right now.  I hate saying that, because I hate windows 
products.  I really would like to make this work under Unix!!
 
Thanks.
Nancy 

 


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: (DBD ERROR: LOB refetch attempted for unsupported statement t ype)

2002-04-11 Thread Mathew Varghese


OSP:

PROCEDURE Add_GFS_cmpdocs (
FIN_C   IN  VARCHAR2,
ACCT_OU_C   IN  VARCHAR2,
COUNTRY_ISO3_C  IN  VARCHAR2,
DOCNAME_N   IN  VARCHAR2,
DOCFILE_X   IN  BLOB,
UPDATED_BY_CIN  VARCHAR2,
Error_Num   OUT NUMBER,
Error_Msg   OUT VARCHAR2)
IS
DOCID_R NUMBER(4);
BEGIN
SELECT MAX(GFSA08_DOCID_R) + 1
INTO DOCID_R
FROM MGFSA08_cmpdocs;

IF DOCID_R IS NULL THEN
   DOCID_R := 1;
END IF;

INSERT INTO lpdevl.MGFSA08_cmpdocs
(GFSA08_DOCID_R,
 ACCT_FIN_C,
 ACCT_OU_C,
 COUNTRY_ISO3_C,
 GFSA08_DOCNAME_N,
 GFSA08_DOCFILE_X,
 GFSA08_UPDATED_BY_C,
 GFSA08_UPDATE_S)
VALUES (
 DOCID_R,
 FIN_C,
 ACCT_OU_C,
 COUNTRY_ISO3_C,
 DOCNAME_N,
--   '',
 DOCFILE_X,
 UPDATED_BY_C,
 SysDate);

 Error_Num := 0;
 Error_Msg := 'Success';
 return;

EXCEPTION
WHEN OTHERS THEN
  Error_Num := SQLCODE;
  Error_Msg := SUBSTR(SQLERRM, 1, 100);
END Add_GFS_cmpdocs;



Perl Code:
sub addGlobalDocs
{
my( $acct_fin_c, $acct_ou_c, $country_iso3_c, $gfsa08_docname_n, 
$in, $u
serid) = @_;
my @dbHandle;
my $sql, $csr;
my $err_num = ;
my $err_msg = ;
Insert Blob from Server
  my $ua = new LWP::UserAgent;
  $ua-timeout(1);
  $url = http://webdev.globalfleetsolutions.ford.com/images/test.pdf;;
  my $curl = url(http);
  my $forms = new CGI;
  my $req = new HTTP::Request 'GET', $url;
  if ( $response-is_success)
  if ( $response-is_success)
  {
$PDF_BLOB = $response-content;
$dbHandle[1]-{LongReadLen} = length($PDF_BLOB) + 1024;
  }
# END ##
$sql  = BEGIN 
gfs.gfs_sp_package_x.add_gfs_cmpdocs(:1,:2,:3,:4,:5,:6,:,
:8); END;;

@dbHandle = openGFSDb();
return Error if (! $#dbHandle );
$dbHandle[1]-{LongReadLen} = length($PDF_BLOB) + 2048;
$dbHandle[1]-{LongTruncOk}=1;
$csr = $dbHandle[1]-prepare ($sql) || die $csr-errstr;
my %attrib = ();
$attrib{'ora_type'} = 24;
$csr-bind_param(1,$acct_fin_c);
$csr-bind_param(2,$acct_ou_c);
$csr-bind_param(3,$country_iso3_c);
$csr-bind_param(4,$gfsa08_docname_n);

  $csr-bind_param(5, $PDF_BLOB, {ora_type = ORA_BLOB}  );

$csr-bind_param(6,$userid);
$csr-bind_param_inout(7,\$err_num,100);
$csr-bind_param_inout(8,\$err_msg,1000);

$err_num = ;
$err_msg =   ;
$cnt = $csr-execute () || Execute failed : $DBI::errstr;
print Count1: $cntbr;
$cnt = $csr-finish () || Finish failed : $DBI::errstr;
print Count2: $cntbr;

#   $cnt = $dbHandle[1]-commit || Commit failed : $DBI::errstr;
print Count3: $cntbr;


if ($dbHandle[0] == 1) { $dbHandle[1]-disconnect;}
}

sub openGFSDb
{
my ($user,$password,$database,$dbh,$drv);
my (@ret_results);

$drv = 'Oracle';
#if (apollo eq $ENV{SERVER_NAME}) {
#  $user = 'fleet@orcl';
#  $password = 'fleet';
#  $database = '';
#}
$user = 'XXX';
$password = 'XXX';
$database = 'eccdb39_mssp7.world';
#$database = '19.5.38.97';
$database = 'eccdb8_mssdevl.world';
if ( $ENV{SERVER_NAME} eq webdev.globalfleetsolutions.ford.com )
{
  $database = 'eccdb8_mssdevl.world';
}
else
{
  $database = 'eccdb39_mssp7.world';
}
if ($dbh = DBI-connect($database,$user,$password,$drv))
{
#$dbh-{AutoCommit} = 0;
push(@ret_results, 1);
push(@ret_results, $dbh);
}
else
{
$error = $module_name .   . $DBI::errstr;
print Unable to open the database, $database; user, $user 
(ORACLE_HOME
$ENV{'ORACLE_HOME'} ) in module $module_name due to the following error:  . 
$DB
I::errs push(@ret_results, 0);
}

return(@ret_results);
}


From: Sterin, Ilya [EMAIL PROTECTED]
To: 'Mathew Varghese ' [EMAIL PROTECTED], '[EMAIL PROTECTED] '  
[EMAIL PROTECTED]
Subject: RE: (DBD ERROR: LOB refetch attempted for unsupported statement t 
ype)
Date: Thu, 11 Apr 2002 10:22:23 -0600

Code, code, let us see the code please...

Show me your flowcharts and conceal your tables, and I shall continue to be
mystified. Show me your tables, and I won't usually need your flowcharts;
they'll be obvious.  Fred Brooks...

Ilya

-Original Message-
From: Mathew Varghese
To: [EMAIL PROTECTED]
Sent: 4/11/02 10:04 AM
Subject: (DBD ERROR: LOB refetch attempted for unsupported statement type)

(DBD ERROR: LOB refetch attempted

Re: DBD error

2001-05-17 Thread M.W. Koskamp

- Original Message -
From: Theja Rajakumar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 17, 2001 10:34 PM
Subject: DBD error

 I've been getting this error while connecting to an Oracle database
 thro' DBI. and don't know what's happening.
 Can anybody help?

 ORA-12500: TNS:listener failed to start a dedicated server process (DBD
 ERROR: OCIServerAttach) at DbUtils.pm line 104.

For some reason the Oracle dispatcher process wasnt able to start a
dedicated process for you on the server. This is an server side error.
Ask your DBA to investigate this.
You might wanna try to connect to a shared server process rather than a
dedicated process.
To do this put (SERVER = SHARED) in your tnsname.ora file on the client.
See example:

SOME_SID.SOMEHOST =
  (DESCRIPTION =
(ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = SOMEHOST)(PORT = 1526))
)
(CONNECT_DATA =
  (SERVICE_NAME = SOME_SID) (SERVER = SHARED)
)
  )

maarten

RE: DBD error

Re: DBD error

Re: DBD error

Re: DBD error

RE: DBD error

Re: DBD ERROR: LOB refetch attempted for unsupported statement type

RE: DBD Error on test

RE: DBD Error on test

RE: DBD Error on test

RE: (DBD ERROR: LOB refetch attempted for unsupported statement t ype)

Re: DBD error

11 matches

Site Navigation

Mail list logo

Footer information