RE: DBI error
Hi all, Thank you for replying to my question. I am able to resolve the issue with the following: - gcc 4.2.3 - libgcc 4.2.3 -Run time libraries=libiconv.sl, libintl.sl - DBI-1.161 - DBD-1.27 Set the following variables: OH=/opt/app/oracle/product/10.2.0 ORACLE_HOME=$OH SHLIB_PATH=$OH/lib LD_LIBRARY_PATH=$OH/lib ORACLE_SID=IDB ORACLE_USERID=system/password Install DBI first: perl Makefile.PL make make test make install Install DBD last: perl Makefile.PL -l make make test make install -Original Message- From: Matthew Ramadanovic [mailto:matthew.ramadano...@yale.edu] Sent: Tuesday, February 22, 2011 6:37 AM To: Nguyen, Andrew; dbi-users@perl.org Subject: RE: DBI error Have you made sure your environment points to the new Oracle libraries and not old or nonexistent places? We just complete something similar 9i(Sparc)-ia64(11G) and lots of environment variables needed to be changed to reference the correct location. For instance : LD_LIBRARY_PATH=/export/home/oracle/9.2.0/lib Changed to LD_LIBRARY_PATH=/export/home/oracle/111/lib There are many other examples. Make sure whatever account you are trying to compile as has an environment that has been set up correctly. -M -Original Message- From: stacy.ma...@csiro.au [mailto:stacy.ma...@csiro.au] Sent: Tuesday, February 22, 2011 4:55 AM To: andrew.ngu...@pacificlife.com; dbi-users@perl.org Subject: RE: DBI error Have you recompiled DBI against 10.2.0.4? From: Nguyen, Andrew [andrew.ngu...@pacificlife.com] Sent: Tuesday, 22 February 2011 6:14 AM To: 'dbi-users@perl.org' Subject: DBI error Hi, I am Andrew Nguyen with Pacific Life. We are using Perl DBI-1.28 in Oracle 8.1.7 for many years. We just upgraded our Oracle to 10.2.0. And now the DBI does not work anymore.Please advise what to do. Thank you in advance for your help. OS: HP-UX 11.11. Oracle: 10.2.0.4 pmutindx-root-/home/ssg/perl: perl shchgsum.pl install_driver(Oracle) failed: Can't load '/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such f ile or directory at /opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/DynaLoader.pm line 230. at (eval 2) line 3 Compilation failed in require at (eval 2) line 3. Perhaps a required shared library or dll isn't installed where expected at /opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/Oraperl.pm line 58 Compilation failed in require at shchgsum.pl line 22. BEGIN failed--compilation aborted at shchgsum.pl line 22. == The information in this e-mail and any attachments are for the sole use of the intended recipient and may contain privileged and confidential information. If you are not the intended recipient, any use, disclosure, copying or distribution of this message or attachment is strictly prohibited. If you believe that you have received this e-mail in error, please contact the sender immediately and delete the e-mail and all of its attachments. ==
Re: DBI error
On 21/02/11 19:14, Nguyen, Andrew wrote: Hi, I am Andrew Nguyen with Pacific Life. We are using Perl DBI-1.28 in Oracle 8.1.7 for many years. We just upgraded our Oracle to 10.2.0. And now the DBI does not work anymore.Please advise what to do. Thank you in advance for your help. OS: HP-UX 11.11. Oracle: 10.2.0.4 pmutindx-root-/home/ssg/perl: perl shchgsum.pl install_driver(Oracle) failed: Can't load '/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such f ile or directory at /opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/DynaLoader.pm line 230. at (eval 2) line 3 Compilation failed in require at (eval 2) line 3. Perhaps a required shared library or dll isn't installed where expected at /opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/Oraperl.pm line 58 Compilation failed in require at shchgsum.pl line 22. BEGIN failed--compilation aborted at shchgsum.pl line 22. Did you rebuild DBI and DBD::Oracle after upgrading? Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.com
RE: DBI error
Have you recompiled DBI against 10.2.0.4? From: Nguyen, Andrew [andrew.ngu...@pacificlife.com] Sent: Tuesday, 22 February 2011 6:14 AM To: 'dbi-users@perl.org' Subject: DBI error Hi, I am Andrew Nguyen with Pacific Life. We are using Perl DBI-1.28 in Oracle 8.1.7 for many years. We just upgraded our Oracle to 10.2.0. And now the DBI does not work anymore.Please advise what to do. Thank you in advance for your help. OS: HP-UX 11.11. Oracle: 10.2.0.4 pmutindx-root-/home/ssg/perl: perl shchgsum.pl install_driver(Oracle) failed: Can't load '/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such f ile or directory at /opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/DynaLoader.pm line 230. at (eval 2) line 3 Compilation failed in require at (eval 2) line 3. Perhaps a required shared library or dll isn't installed where expected at /opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/Oraperl.pm line 58 Compilation failed in require at shchgsum.pl line 22. BEGIN failed--compilation aborted at shchgsum.pl line 22. == The information in this e-mail and any attachments are for the sole use of the intended recipient and may contain privileged and confidential information. If you are not the intended recipient, any use, disclosure, copying or distribution of this message or attachment is strictly prohibited. If you believe that you have received this e-mail in error, please contact the sender immediately and delete the e-mail and all of its attachments. ==
RE: DBI error
Have you made sure your environment points to the new Oracle libraries and not old or nonexistent places? We just complete something similar 9i(Sparc)-ia64(11G) and lots of environment variables needed to be changed to reference the correct location. For instance : LD_LIBRARY_PATH=/export/home/oracle/9.2.0/lib Changed to LD_LIBRARY_PATH=/export/home/oracle/111/lib There are many other examples. Make sure whatever account you are trying to compile as has an environment that has been set up correctly. -M -Original Message- From: stacy.ma...@csiro.au [mailto:stacy.ma...@csiro.au] Sent: Tuesday, February 22, 2011 4:55 AM To: andrew.ngu...@pacificlife.com; dbi-users@perl.org Subject: RE: DBI error Have you recompiled DBI against 10.2.0.4? From: Nguyen, Andrew [andrew.ngu...@pacificlife.com] Sent: Tuesday, 22 February 2011 6:14 AM To: 'dbi-users@perl.org' Subject: DBI error Hi, I am Andrew Nguyen with Pacific Life. We are using Perl DBI-1.28 in Oracle 8.1.7 for many years. We just upgraded our Oracle to 10.2.0. And now the DBI does not work anymore.Please advise what to do. Thank you in advance for your help. OS: HP-UX 11.11. Oracle: 10.2.0.4 pmutindx-root-/home/ssg/perl: perl shchgsum.pl install_driver(Oracle) failed: Can't load '/opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/auto/DBD/Oracle/Oracle.sl' for module DBD::Oracle: No such f ile or directory at /opt/perl_32/lib/5.8.8/PA-RISC1.1-thread-multi/DynaLoader.pm line 230. at (eval 2) line 3 Compilation failed in require at (eval 2) line 3. Perhaps a required shared library or dll isn't installed where expected at /opt/perl_32/lib/site_perl/5.8.8/PA-RISC1.1-thread-multi/Oraperl.pm line 58 Compilation failed in require at shchgsum.pl line 22. BEGIN failed--compilation aborted at shchgsum.pl line 22. == The information in this e-mail and any attachments are for the sole use of the intended recipient and may contain privileged and confidential information. If you are not the intended recipient, any use, disclosure, copying or distribution of this message or attachment is strictly prohibited. If you believe that you have received this e-mail in error, please contact the sender immediately and delete the e-mail and all of its attachments. ==
Re: DBI Error: END failed--call queue aborted.
On Nov 13, 10:19 am, sco...@pythian.com (John Scoles) wrote:
You DBD::ORacle is way out of data for you DBI try updating to DBD::Oracle
1.26 ans see what happens
cheers
The error remains the same :( Thanks for all your help. Not sure what
else I can do here.
-bash-3.00$ cat test.db.pl
use strict;
use DBI;
my $dbh = DBI-connect( 'dbi:Oracle:DELETED',
'DELETED',
'DELETED',
{dbd_verbose = 15}
) || die Database connection not made:
$DBI::errstr;
$dbh-disconnect;
print Done. :)\n;
-bash-3.00$ perl -w test.db.pl
Environment variables:
MANPATH=/opt/SUNWspro/man
TERM=xterm
SHELL=/usr/bin/bash
SSH_CLIENT=172.28.2.66 3369 22
OLDPWD=/export/home/webdev/.cpan
SSH_TTY=/dev/pts/4
USER=webdev
LD_LIBRARY_PATH=/opt/instantclient10_1
TNS_ADMIN=/opt/instantclient10_1
MAIL=/var/mail//webdev
PATH=/usr/bin:/opt/SUNWspro/bin:/opt/instantclient10_1:/usr/
ccs/bin
PWD=/export/home/webdev
JAVA_HOME=/usr/java
TZ=US/Eastern
SHLVL=1
HOME=/export/home/webdev
LOGNAME=webdev
SSH_CONNECTION=172.28.2.66 3369 172.28.1.40 22
ORACLE_HOME=/opt/instantclient10_1
_=/usr/bin/perl
OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS
OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS
OCIEnvNlsEnvCreate(1b56bc,OBJECT,2,0,0,0,0,0,0,1,1)=SUCCESS
OCIHandleAlloc(2500a0,1b56c0,OCI_HTYPE_ERROR,0,0)=SUCCESS
OCIAttrGet(2500a0,OCI_HTYPE_ENV,fee78090,0,31,267a28)=SUCCESS
OCIAttrGet(2500a0,OCI_HTYPE_ENV,fee78092,0,262,267a28)=SUCCESS
charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII
(csid: utf8=871 al32utf8=873)
OCIHandleAlloc(2500a0,1b56c4,OCI_HTYPE_SERVER,0,0)=SUCCESS
OCIHandleAlloc(2500a0,1b56c8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
OCIServerAttach(267fb4, 267a28, AHST90, 6, mode=DEFAULT,
0)=SUCCESS
OCIAttrSet(2679b4,OCI_HTYPE_SVCCTX,
267fb4,0,Attr=OCI_ATTR_SERVER,267a28)=SUCCESS
OCIHandleAlloc(2500a0,1b56cc,OCI_HTYPE_SESSION,0,0)=SUCCESS
OCIAttrSet(270ca8,OCI_HTYPE_SESSION,
1a6380,3,Attr=OCI_ATTR_USERNAME,267a28)=SUCCESS
OCIAttrSet(270ca8,OCI_HTYPE_SESSION,
1a6390,5,Attr=OCI_ATTR_PASSWORD,267a28)=SUCCESS
OCISessionBegin(2679b4,267a28,270ca8,1,mode=DEFAULT 0)=SUCCESS
OCIAttrSet(2679b4,OCI_HTYPE_SVCCTX,
270ca8,0,Attr=OCI_ATTR_SESSION,267a28)=SUCCESS
OCISessionEnd(2679b4,267a28,270ca8,mode=DEFAULT 0)=SUCCESS
OCIServerDetach(267fb4,267a28,mode=DEFAULT,0)=SUCCESS
Done. :)
OCIHandleFree(270ca8,OCI_HTYPE_SESSION)=SUCCESS
OCIHandleFree(2679b4,OCI_HTYPE_SVCCTX)=SUCCESS
OCIHandleFree(267fb4,OCI_HTYPE_SERVER)=SUCCESS
OCIHandleFree(267a28,OCI_HTYPE_ERROR)=SUCCESS
Out of memory!
Callback called exit.
END failed--call queue aborted.
--
i5mast
RE: DBI Error: END failed--call queue aborted.
Ok that cleans it up a little for me.
Funny according to the OIC trace you are connecting
see below
To: dbi-users@perl.org
From: mstrum...@gmail.com
Subject: Re: DBI Error: END failed--call queue aborted.
Date: Wed, 17 Nov 2010 07:50:30 -0800
On Nov 13, 10:19 am, sco...@pythian.com (John Scoles) wrote:
You DBD::ORacle is way out of data for you DBI try updating to DBD::Oracle
1.26 ans see what happens
cheers
The error remains the same :( Thanks for all your help. Not sure what
else I can do here.
-bash-3.00$ cat test.db.pl
use strict;
use DBI;
my $dbh = DBI-connect( 'dbi:Oracle:DELETED',
'DELETED',
'DELETED',
{dbd_verbose = 15}
) || die Database connection not made:
$DBI::errstr;
$dbh-disconnect;
print Done. :)\n;
-bash-3.00$ perl -w test.db.pl
Environment variables:
MANPATH=/opt/SUNWspro/man
TERM=xterm
SHELL=/usr/bin/bash
SSH_CLIENT=172.28.2.66 3369 22
OLDPWD=/export/home/webdev/.cpan
SSH_TTY=/dev/pts/4
USER=webdev
LD_LIBRARY_PATH=/opt/instantclient10_1
TNS_ADMIN=/opt/instantclient10_1
MAIL=/var/mail//webdev
PATH=/usr/bin:/opt/SUNWspro/bin:/opt/instantclient10_1:/usr/
ccs/bin
PWD=/export/home/webdev
JAVA_HOME=/usr/java
TZ=US/Eastern
SHLVL=1
HOME=/export/home/webdev
LOGNAME=webdev
SSH_CONNECTION=172.28.2.66 3369 172.28.1.40 22
ORACLE_HOME=/opt/instantclient10_1
_=/usr/bin/perl
OCINlsEnvironmentVariableGet(1,0,93,0,2)=SUCCESS
OCINlsEnvironmentVariableGet(1,0,94,0,2)=SUCCESS
OCIEnvNlsEnvCreate(1b56bc,OBJECT,2,0,0,0,0,0,0,1,1)=SUCCESS
OCIHandleAlloc(2500a0,1b56c0,OCI_HTYPE_ERROR,0,0)=SUCCESS
OCIAttrGet(2500a0,OCI_HTYPE_ENV,fee78090,0,31,267a28)=SUCCESS
OCIAttrGet(2500a0,OCI_HTYPE_ENV,fee78092,0,262,267a28)=SUCCESS
charset id=1, name=US7ASCII, ncharset id=1, name=US7ASCII
(csid: utf8=871 al32utf8=873)
The above set up you server context
OCIHandleAlloc(2500a0,1b56c4,OCI_HTYPE_SERVER,0,0)=SUCCESS
OCIHandleAlloc(2500a0,1b56c8,OCI_HTYPE_SVCCTX,0,0)=SUCCESS
OCIServerAttach(267fb4, 267a28, AHST90, 6, mode=DEFAULT, 0)=SUCCESS
OCIAttrSet(2679b4,OCI_HTYPE_SVCCTX,267fb4,0,Attr=OCI_ATTR_SERVER,267a28)=SUCCESS
OCIHandleAlloc(2500a0,1b56cc,OCI_HTYPE_SESSION,0,0)=SUCCESS
The above sets up all your handles
OCIAttrSet(270ca8,OCI_HTYPE_SESSION,1a6380,3,Attr=OCI_ATTR_USERNAME,267a28)=SUCCESS
OCIAttrSet(270ca8,OCI_HTYPE_SESSION,1a6390,5,Attr=OCI_ATTR_PASSWORD,267a28)=SUCCESS
OCISessionBegin(2679b4,267a28,270ca8,1,mode=DEFAULT 0)=SUCCESS
OCIAttrSet(2679b4,OCI_HTYPE_SVCCTX,
270ca8,0,Attr=OCI_ATTR_SESSION,267a28)=SUCCESS
The above users your PW and UN and creates a session and it connects
The rest below is what happens when you disconnects
OCISessionEnd(2679b4,267a28,270ca8,mode=DEFAULT 0)=SUCCESS
OCIServerDetach(267fb4,267a28,mode=DEFAULT,0)=SUCCESS
Done. :)
OCIHandleFree(270ca8,OCI_HTYPE_SESSION)=SUCCESS
OCIHandleFree(2679b4,OCI_HTYPE_SVCCTX)=SUCCESS
OCIHandleFree(267fb4,OCI_HTYPE_SERVER)=SUCCESS
OCIHandleFree(267a28,OCI_HTYPE_ERROR)=SUCCESS
You are now our of OCI/DBD/Oracle
Out of memory!
So this Out of memory error happens after you have left
Can you run a query with your connection handle??
Callback called exit.
END failed--call queue aborted.
--
i5mast
Re: DBI Error: END failed--call queue aborted.
On Nov 12, 8:24 am, sco...@pythian.com (John Scoles) wrote:
If you can run this with
dbd_verbose=15
on the connect string the post the results it my help us find an answer.
Cheers
John Scoles
John, I added dbd_verbose but that didn't print any debugging info :(
DBI-connect( 'dbi:Oracle:AHST90',
'ahs',
'ahsgc',
{dbd_verbose = 15}
)
I ran the script with DBI_TRACE=15 and got the following info. I
edited the output below and removed user login and SID.
I appreciate any help.
-bash-3.00$ DBI_TRACE=15 perl -w test.db.pl
DBI 1.53-nothread default trace level set to 0x0/15 (pid 28069)
0x2a00 DBI::db::get_info
install_method DBI::db::get_info, flags 0x2a00,
usage: min 2, max 2, '$info_type'
0x DBI::db::take_imp_data
install_method DBI::db::take_imp_data,
usage: min 1, max 1, ''
0x0c00 DBI::db::disconnect
install_method DBI::db::disconnect , flags 0x0c00,
usage: min 1, max 1, ''
0x2000 DBI::db::selectrow_array
install_method DBI::db::selectrow_array, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x2200 DBI::db::tables
install_method DBI::db::tables , flags 0x2200,
usage: min 1, max 6, '$catalog, $schema, $table, $type [, \
%attr ]'
0x0430 DBI::db::quote_identifier
install_method DBI::db::quote_identifier, flags 0x0430,
usage: min 2, max 6, '$name [, ...] [, \%attr ]'
0x DBI::db::clone
install_method DBI::db::clone ,
usage: min 1, max 2, '[\%attr]'
0x0430 DBI::db::quote
install_method DBI::db::quote , flags 0x0430,
usage: min 2, max 3, '$string [, $data_type ]'
0x2200 DBI::db::type_info
install_method DBI::db::type_info , flags 0x2200,
usage: min 1, max 2, '$data_type'
0x2a00 DBI::db::statistics_info
install_method DBI::db::statistics_info, flags 0x2a00,
usage: min 6, max 7, '$catalog, $schema, $table, $unique_only,
$quick, [, \%attr ]'
0x2000 DBI::db::selectrow_arrayref
install_method DBI::db::selectrow_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x0400 DBI::db::begin_work
install_method DBI::db::begin_work , flags 0x0400,
usage: min 1, max 2, '[ \%attr ]'
0x2800 DBI::db::last_insert_id
install_method DBI::db::last_insert_id, flags 0x2800,
usage: min 5, max 6, '$catalog, $schema, $table_name, $field_name
[, \%attr ]'
0x2a00 DBI::db::foreign_key_info
install_method DBI::db::foreign_key_info, flags 0x2a00,
usage: min 7, max 8, '$pk_catalog, $pk_schema, $pk_table,
$fk_catalog, $fk_schema, $fk_table [, \%attr ]'
0x2200 DBI::db::primary_key
install_method DBI::db::primary_key , flags 0x2200,
usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]'
0x0c80 DBI::db::commit
install_method DBI::db::commit , flags 0x0c80,
usage: min 1, max 1, ''
0x0404 DBI::db::ping
install_method DBI::db::ping, flags 0x0404,
usage: min 1, max 1, ''
0x2000 DBI::db::selectall_arrayref
install_method DBI::db::selectall_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x2a00 DBI::db::type_info_all
install_method DBI::db::type_info_all, flags 0x2a00,
usage: min 1, max 1, ''
0x3200 DBI::db::do
install_method DBI::db::do , flags 0x3200,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x2000 DBI::db::selectcol_arrayref
install_method DBI::db::selectcol_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x2200 DBI::db::prepare_cached
install_method DBI::db::prepare_cached, flags 0x2200,
usage: min 2, max 4, '$statement [, \%attr [, $if_active ] ]'
0x0004 DBI::db::rows
install_method DBI::db::rows, flags 0x0004
0x0c80 DBI::db::rollback
install_method DBI::db::rollback, flags 0x0c80,
usage: min 1, max 1, ''
0x2a00 DBI::db::column_info
install_method DBI::db::column_info , flags 0x2a00,
usage: min 5, max 6, '$catalog, $schema, $table, $column [, \
%attr ]'
0x2a00 DBI::db::table_info
install_method DBI::db::table_info , flags 0x2a00,
usage: min 1, max 6, '$catalog, $schema, $table, $type [, \
%attr ]'
0x2a00 DBI::db::primary_key_info
install_method DBI::db::primary_key_info, flags 0x2a00,
usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]'
0x2200 DBI::db::prepare
install_method DBI::db::prepare , flags 0x2200,
usage: min 2, max 3, '$statement [, \%attr]'
0x DBI::db::preparse
install_method DBI::db::preparse
0x0100 DBI::db::connected
install_method DBI::db::connected , flags 0x0100
0x0200 DBI::db::data_sources
install_method DBI::db::data_sources, flags 0x0200,
usage: min 1, max 2, '[\%attr]'
0x2000 DBI::db::selectall_hashref
install_method DBI::db::selectall_hashref, flags 0x2000,
usage: min 3, max 0, '$statement, $keyfield [, \%attr [,
@bind_params ] ]'
0x2000 DBI::db::selectrow_hashref
install_method DBI::db::selectrow_hashref, flags 0x2000,
usage: min 2, max 0,
Re: DBI Error: END failed--call queue aborted.
Well nothing in that pops out at me.
You DBD::ORacle is way out of data for you DBI try updating to DBD::Oracle
1.26 ans see what happens
cheers
On Fri, Nov 12, 2010 at 3:49 PM, i5mast mstrum...@gmail.com wrote:
On Nov 12, 8:24 am, sco...@pythian.com (John Scoles) wrote:
If you can run this with
dbd_verbose=15
on the connect string the post the results it my help us find an answer.
Cheers
John Scoles
John, I added dbd_verbose but that didn't print any debugging info :(
DBI-connect( 'dbi:Oracle:AHST90',
'ahs',
'ahsgc',
{dbd_verbose = 15}
)
I ran the script with DBI_TRACE=15 and got the following info. I
edited the output below and removed user login and SID.
I appreciate any help.
-bash-3.00$ DBI_TRACE=15 perl -w test.db.pl
DBI 1.53-nothread default trace level set to 0x0/15 (pid 28069)
0x2a00 DBI::db::get_info
install_method DBI::db::get_info, flags 0x2a00,
usage: min 2, max 2, '$info_type'
0x DBI::db::take_imp_data
install_method DBI::db::take_imp_data,
usage: min 1, max 1, ''
0x0c00 DBI::db::disconnect
install_method DBI::db::disconnect , flags 0x0c00,
usage: min 1, max 1, ''
0x2000 DBI::db::selectrow_array
install_method DBI::db::selectrow_array, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x2200 DBI::db::tables
install_method DBI::db::tables , flags 0x2200,
usage: min 1, max 6, '$catalog, $schema, $table, $type [, \
%attr ]'
0x0430 DBI::db::quote_identifier
install_method DBI::db::quote_identifier, flags 0x0430,
usage: min 2, max 6, '$name [, ...] [, \%attr ]'
0x DBI::db::clone
install_method DBI::db::clone ,
usage: min 1, max 2, '[\%attr]'
0x0430 DBI::db::quote
install_method DBI::db::quote , flags 0x0430,
usage: min 2, max 3, '$string [, $data_type ]'
0x2200 DBI::db::type_info
install_method DBI::db::type_info , flags 0x2200,
usage: min 1, max 2, '$data_type'
0x2a00 DBI::db::statistics_info
install_method DBI::db::statistics_info, flags 0x2a00,
usage: min 6, max 7, '$catalog, $schema, $table, $unique_only,
$quick, [, \%attr ]'
0x2000 DBI::db::selectrow_arrayref
install_method DBI::db::selectrow_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x0400 DBI::db::begin_work
install_method DBI::db::begin_work , flags 0x0400,
usage: min 1, max 2, '[ \%attr ]'
0x2800 DBI::db::last_insert_id
install_method DBI::db::last_insert_id, flags 0x2800,
usage: min 5, max 6, '$catalog, $schema, $table_name, $field_name
[, \%attr ]'
0x2a00 DBI::db::foreign_key_info
install_method DBI::db::foreign_key_info, flags 0x2a00,
usage: min 7, max 8, '$pk_catalog, $pk_schema, $pk_table,
$fk_catalog, $fk_schema, $fk_table [, \%attr ]'
0x2200 DBI::db::primary_key
install_method DBI::db::primary_key , flags 0x2200,
usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]'
0x0c80 DBI::db::commit
install_method DBI::db::commit , flags 0x0c80,
usage: min 1, max 1, ''
0x0404 DBI::db::ping
install_method DBI::db::ping, flags 0x0404,
usage: min 1, max 1, ''
0x2000 DBI::db::selectall_arrayref
install_method DBI::db::selectall_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x2a00 DBI::db::type_info_all
install_method DBI::db::type_info_all, flags 0x2a00,
usage: min 1, max 1, ''
0x3200 DBI::db::do
install_method DBI::db::do , flags 0x3200,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x2000 DBI::db::selectcol_arrayref
install_method DBI::db::selectcol_arrayref, flags 0x2000,
usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]'
0x2200 DBI::db::prepare_cached
install_method DBI::db::prepare_cached, flags 0x2200,
usage: min 2, max 4, '$statement [, \%attr [, $if_active ] ]'
0x0004 DBI::db::rows
install_method DBI::db::rows, flags 0x0004
0x0c80 DBI::db::rollback
install_method DBI::db::rollback, flags 0x0c80,
usage: min 1, max 1, ''
0x2a00 DBI::db::column_info
install_method DBI::db::column_info , flags 0x2a00,
usage: min 5, max 6, '$catalog, $schema, $table, $column [, \
%attr ]'
0x2a00 DBI::db::table_info
install_method DBI::db::table_info , flags 0x2a00,
usage: min 1, max 6, '$catalog, $schema, $table, $type [, \
%attr ]'
0x2a00 DBI::db::primary_key_info
install_method DBI::db::primary_key_info, flags 0x2a00,
usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]'
0x2200 DBI::db::prepare
install_method DBI::db::prepare , flags 0x2200,
usage: min 2, max 3, '$statement [, \%attr]'
0x DBI::db::preparse
install_method DBI::db::preparse
0x0100 DBI::db::connected
install_method DBI::db::connected , flags 0x0100
0x0200 DBI::db::data_sources
install_method DBI::db::data_sources, flags 0x0200,
usage: min 1, max 2,
Re: DBI Error: END failed--call queue aborted.
On 10/11/2010 11:11 AM, i5mast wrote: If you can run this with dbd_verbose=15 on the connect string the post the results it my help us find an answer. Cheers John Scoles I'm using Solaris 10 sparc, Perl 5.8.4, DBI 1.615, instantclient 10.1.0.5, DBD::Oracle 1.16. I compiled and installed the modules successfully. I can connect to DB and fetch records just fine. However, when my perl script finishes, it prints out the error. I'm using Sun's compiler cc: Sun C 5.8 Patch 121015-04 2007/01/10 I've tried DBD::Oracle 1.24 and DBI 1.53 versions but the error still happens at the end :( I've read about other people getting this message but no resolution. I would appreciate any help. use strict; use DBI; my $dbh = DBI-connect( 'dbi:Oracle:XXX', 'user', 'passwd', ) || die Database connection not made: $DBI::errstr; $dbh-disconnect; print Done. :)\n; Done. :) Out of memory! Callback called exit. END failed--call queue aborted. -- i5mast
Re: DBI error
Probably you mixed two DBI installations. The 1.40 version may be incomplete, but at least some libraries survived and exist in a directory that is searched before directory where the 1.42 librarys exist. If you install the DBI modules from a package manager (like apt-get, rpm), try to remove and install from CPAN. -Thiago Rondon amos.nak...@seagate.com escreveu: Hi, Am getting the following DBI error. I think l might have too versions installed. How do l un-install one and leave the other? DBI object version 1.40 does not match $DBI::VERSION 1.42 at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 253. BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.8.5 /i386-linux-thread-multi/DBI.pm line 259. Compilation failed in require at /apps/code/e3.pl line 4. BEGIN failed--compilation aborted at /apps/code/e3.pl line 4 Regards, Amos Nakolo IT Systems Engineer Seagate Oklahoma
Re: DBI error
On Tue, 29 Jan 2008 13:44:16 -0700, Kirthi Prabhu wrote: I get the pg.pm file and I have placed that in DBD/ folder. Generally not a good sign... When I use DBI - Connect I get the following error install_driver(Pg) failed: Can't locate loadable object for module DBD::Pg in @INC I was expecting that. This means you don't have the DLL that belongs to DBD::Pg. Just copying the Pure Perl part of the module is not good enough. Just install the DBD::PG module properly, for example with PPM, instead of his halfhearted attempt, which you should not undertake unless you know very much what you're doing (in which case you wouldn't be asking about this error...) -- Bart.
RE: DBI - error
Sumitra Gatade wrote: Hi, I am trying to execute the stored procedure using dbh. The procedure details are as follows: proc_dequeue( BALID,strRequestXML,strStatus) where: BALID - Integer, strRequestXML - XMLType, strStatus - varchar The perl script implemented is : my $sth = $dbh1-prepare(begin proc_dequeue(:BALID,:strRequestXML,:strStatus); end;); $sth-bind_param_inout(:BALID,\$o_balid,20,\%attr ); $sth-bind_param_inout(:strRequestXML,\$o_requestXML,5,\%attr); $sth-bind_param_inout(:strStatus,\$o_status,2,\%attr); and the error message i am getting is : DBD::Oracle::st execute failed: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'proc_dequeue' You are passing a string to a function that expects XMLType, an opaque Oracle object type. The XMLType API provides a constructor that takes a varchar2 argument, so try changing your statement to: begin proc_dequeue(:BALID,XMLType(:strRequestXML),:strStatus); end; Regards, Philip
RE: DBI - error
This is not a DBI or a perl issue. Read your error stack and resolve your Oracle issue. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Sumitra Gatade [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 07, 2006 6:01 AM To: dbi-users@perl.org Subject: DBI - error Hi, I am trying to execute the stored procedure using dbh. The procedure details are as follows: proc_dequeue( BALID,strRequestXML,strStatus) where: BALID - Integer, strRequestXML - XMLType, strStatus - varchar The perl script implemented is : my $sth = $dbh1-prepare(begin proc_dequeue(:BALID,:strRequestXML,:strStatus); end;); $sth-bind_param_inout(:BALID,\$o_balid,20,\%attr ); $sth-bind_param_inout(:strRequestXML,\$o_requestXML,5,\%attr); $sth-bind_param_inout(:strStatus,\$o_status,2,\%attr); and the error message i am getting is : DBD::Oracle::st execute failed: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'proc_dequeue' ORA-06550: line 1, column 7: PL/SQL: Statement ignored (DBD ERROR: OCIStmtExecute) at ./ListenerBalA line 32. DBD::Oracle::st execute failed: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'proc_dequeue' Please help me to resolve this problem. Thanks in advance. Regards, Sumitra Tech Mahindra, formerly Mahindra-British Telecom. Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review at a href=http://www.techmahindra.com/Disclaimer.html;http://www.techmahind ra.com/Disclaimer.html/a externally and a href=http://tim.techmahindra.com/Disclaimer.html;http://tim.techmahind ra.com/Disclaimer.html/a internally within Tech Mahindra. 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: [dbi] error string being lost in DBD::ODBC
Adam,
Have you tried:
odbc_async_exec
Allow asynchronous execution of queries. Right now,
this causes a spin-loop (with a small sleep) until
the sql is complete. This is useful, however, if you
want the error handling and asynchronous messages (see
the err_handler) below. See t/20SQLServer.t for an
example of this.
setting this (from DBD::ODBC pod).
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development
On 01-Aug-2005 Mitchell, Adam R wrote:
I'm having a problem where the error string from a raiserror (inside a
stored procedure) is disappearing. I've reduced it to the fact that it
only occurs if there is some part of the stored procedure that returns
rows (0 or more).
Here is a code snippet that illustrates the problem:
use DBI;
use DBD::ODBC;
my $dbh = DBI-connect(my_sqlserver_database,myuser,mypass);
$sql = create procedure test_raiserror1
as begin
raiserror('my error',16,1) with nowait
end;
$dbh-do($sql) || die $DBD::errstr;
$sql = create procedure test_raiserror2
as begin
select (1)
raiserror('my error',16,1) with nowait
end;
$dbh-do($sql) || die $DBD::errstr;
print created\n\n;
#this bit correctly returns my error into dbi::errstr
$sql = test_raiserror1;
print test_raiserror1:\n;
$rows = $dbh-do($sql);
print rows: $rows\n;
print errstr: $DBI::errstr\n\n;
#this one does not
$sql = test_raiserror2;
print test_raiserror2:\n;
$rows = $dbh-do($sql);
print rows: $rows\n;
print errstr: $DBI::errstr\n\n;
$sql = drop procedure test_raiserror1;
$dbh-do($sql) || die $DBD::errstr;
$sql = drop procedure test_raiserror2;
$dbh-do($sql) || die $DBD::errstr;
print dropped\n\n;
Note how the first one returns the error, while the second one simply
returns -1.
I think it may have to do with the string returned from sql server.
Here is the difference in the return string when they are executed in ms
sql query analyzer:
test1:
Server: Msg 5, Level 16, State 1, Procedure test_raiserror1, Line 4
my error
test2:
(1 row(s) affected)
Server: Msg 5, Level 16, State 1, Procedure test_raiserror1, Line 4
my error
Does anyone know how I can get at the error string?
Thanks,
Adam Mitchell
Re: DBI error handling
Howdy! On Tue, Feb 25, 2003 at 09:46:07PM +, Tim Bunce wrote: On Tue, Feb 25, 2003 at 03:14:24PM -0500, Michael Houghton wrote: Howdy! I'm trying to write a WARN handler for an Informix application. I want to be able to get to stuff in the SQLCA, which, if I read things correctly, means I need the statement handle for the offending action. I have not figured out how to get that without resorting to a global- like variable. Is there some secret handshake that will let me obtain the last statement handle that was invoked? $DBI::lasth will give you the last handle used to make a DBI call. But if that was a statement handle that's now been destroyed it'll return the parent dbh instead. I had seen that variable, but had not yet researched it's use, etc. It sounds like exactly what I want; I think the statement handle wil still be valid when I am in the WARN handler (since I am looking to use PrintError to get me there). Thanks! I'll give this a shot. yours, Michael -- Michael and MJ Houghton | Herveus d'Ormonde and Megan O'Donnelly [EMAIL PROTECTED] | White Wolf and the Phoenix Bowie, MD, USA| Tablet and Inkle bands, and other stuff | http://www.radix.net/~herveus/
Re: DBI error handling
Michael Houghton wrote:
I'm trying to write a WARN handler for an Informix application.
I want to be able to get to stuff in the SQLCA, which, if I read
things correctly, means I need the statement handle for the offending
action.
I have not figured out how to get that without resorting to a global-
like variable.
Is there some secret handshake that will let me obtain the last statement
handle that was invoked?
I've looked at the Cheetah book, scanned the last couple months of the
archives here, checked dbi.perl.org (or was it .com?), and given the
source a (very) cursory overlook, all to no avail.
I'd be grateful for clues and pointers to clues.
There are 5 tests in the t directory for DBD::Informix which mess with
WARN handlers, but none do exactly what you want. However, if you can
set your warning handler locally, can't you use Perl's anonymous subs
to deal with it?
$SIG{__WARN__} = sub { do_the_real_job($sth, $_[0]); };
$sth-...
$SIG{__WARN__} = 'DEFAULT';
When the handler sub is executed, doesn't this use the $sth in scope
when the sub is defined? That's an unverified hypothesis...
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
#include disclaimer.h
Guardian of DBD::Informix 1.04.PC1 -- http://dbi.perl.org/
Re: DBI Error
On Sat, 17 Aug 2002 23:09:30 -0400 WAZA,SANJAY (Non-HP-PaloAlto,ex1)
[EMAIL PROTECTED] wrote:
I am running this simple script on HP UX 11.0 (64 BIT) . The database is
Oracle 9.2.0
#!/opt/perl5.6.1/bin/perl
#!/opt/perl5.6.1/bin/perl -w
use DBI;
# -w and 'use strict;' show you small problems before they become big ones
use strict;
print hello\n ;
$dbh = DBI-connect(mydb,scott,tiger,'Oracle') ;
# You _really_ need to check for errors.
# run `perldoc DBI` to see the newer (5 years old) connect() syntax
my $dbh = DBI - connect( dbi:Oracle:mydb, scott, tiger,
{ PrintError = 0, RaiseError = 1, AutoCommit = 0 } );
I am getting this error
install_driver(Oracle) failed: Can't load
'/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle.sl'
for module DBD::Oracle: No such file or dire
ctory at /opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
Did you read the error message?
If Oracle.sl is in the directory mentioned, then one of the shared
libraries it calls could not be found, probably OCI.sl or something similar
which is normally in $ORACLE_HOME/lib .
Shared libraries are usually located via LD_LIBRARY_PATH which _MUST_ be
set before the Perl interpreter starts. Oracle.sl is an exception since it
must be in a known location relative to DBD/Oracle.pm. Another environment
variable that should be set before the script starts is ORACLE_HOME.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
Re: DBI Error
On Sun, 18 Aug 2002 13:23:28 -0400 WAZA,SANJAY (Non-HP-PaloAlto,ex1)
[EMAIL PROTECTED] wrote:
I changed the script as you suggested
#!/opt/perl5.6.1/bin/perl -w
use strict;
use DBI;
my $dbh = DBI-connect( 'dbi:Oracle:p1db',
'partner1',
'p1admin',
{
RaiseError = 1,
AutoCommit = 0
}
) || die Database connection not made:
$DBI::errstr;
If I want a custom error message I normally use { PrintError = 0,
RaiseError = 0, AutoCommit = 0 } and then set $dbh - {RaiseError} to 1
after connect(). Otherwise, connect() never returns on error. I normally
use something like Can't connect to $sInst as $sUser, $DBI::errstr\n. It
may not be necessary for you though, since the instance and username have
been added to the RaiseError message in recent versions of DBI.
The Error is still the same .
install_driver(Oracle) failed: Can't load
'/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle.sl'
for module DBD::Oracle: No such file or dire
ctory at /opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line 206.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
Before Running the script I set up all the env valiables
export ORACLE_HOME=/archive/newdisk/oracle9i
export SHLIB_PATH=/opt/perl5.6.1/lib:$ORACLE_HOME/lib:/usr/lib
export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/Apache/Apache/libexec
export
PERL5LIB=/opt/perl5.6.1/lib/site_perl/5.6.1:/opt/perl5.6.1/lib/5.6.1:
/opt/perl5.6.1/lib/5.6.1/PA-RISC2.0:/opt/perl5.6.1/lib/site_perl/5.6.1/PA
-RISC2.0
That all looks reasonable, but now I'm wondering what version of Oracle
DBD::Oracle was compiled against. If it wasn't 9.0, you will need to get
it rebuild with 9.0 or use an Oracle Home of the appropriate version.
Since Oracle OCI (used by DBD::Oracle) normally connects through SQL*Net,
you can connect to any database from 7 through 9 using a SQL*Net client
of the version you compiled DBD::Oracle against, if you try to use another
version it probably won't work.
The File Oracle.sl is present in that directory
boi307@/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle% ll
total 12976
-rwxr-xr-x 1 binbin 0 Feb 1 2002 Oracle.bs
-rwxr-xr-x 1 binbin 2402 May 2 2000 Oracle.h
-rwxr-xr-x 1 binbin6602752 Feb 1 2002 Oracle.sl
-rwxr-xr-x 1 binbin 9868 Aug 30 2001 dbdimp.h
-rwxr-xr-x 1 binbin 15733 Feb 1 2002 mk.pm
-rwxr-xr-x 1 binbin 11204 Aug 30 2001 ocitrace.h
Next went to ORACLE_HOME/lib and did ll *oc* and got these results
boi307@/archive/newdisk/oracle9i/lib% ll *oc*
lrwxrwxr-x 1 oracle dba 14 Aug 6 12:50 libocci.sl -
libocci.sl.9.0
-rwxr-xr-x 1 oracle dba 953832 Apr 27 11:12 libocci.sl.9.0
-rw-r--r-- 1 oracle dba4549378 Apr 27 07:36 libocci9.a
-rw-r--r-- 1 oracle dba 211302 Apr 26 04:01 libocijdbc9.a
-rwxr-xr-x 1 oracle dba 155248 Apr 27 12:50 libocijdbc9.sl
-rwxr-xr-x 1 oracle dba 188120 Apr 27 12:50
libocijdbc9_g.sl
-rw-r--r-- 1 oracle dba 211302 Apr 26 04:01 libocijdbcst9.a
So I am not sure how to find exactly which shared library it is looking
for?
_IF_ DBD::Oracle was built with Oracle 9.0, it is probably wants
libocci.sl or libocci.sl.9.0 linked via libocci9.a. If it was build with
another version of Oracle, it is probably looking for another shared
library which would exist in $ORACLE_HOME/lib in an Oracle instance of the
correct version.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
RE: DBI Error
/lib/Oraperl.pm
/bin/perl -p -e s/~DRIVER~/Oracle/g
/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI/Driver.xst
Oracle.xsi
/bin/perl -I/opt/perl5.6.1/lib/5.6.1/PA-RISC2.0
-I/opt/perl5.6.1/lib/5.6.1 /opt/perl5.6.1/lib/5.6.1/ExtUtils/xsubpp
-typemap /opt/perl5.6.1/lib/5.6.1/E
xtUtils/typemap Oracle.xs Oracle.xsc mv Oracle.xsc Oracle.c
cc -c -I/archive/newdisk/oracle9i/rdbms/demo
-I/archive/newdisk/oracle9i/rdbms/public
-I/archive/newdisk/oracle9i/plsql/public -I/archive/newdisk/oracle
9i/network/public -I/archive/newdisk/oracle9i/rdbms/demo
-I/archive/newdisk/oracle9i/rdbms/demo
-I/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX
_SOURCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O
-DVERSION=\1.12\ -DXS_VERSION=\1.12\ +z
-I/opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE Oracle.c
cc -c -I/archive/newdisk/oracle9i/rdbms/demo
-I/archive/newdisk/oracle9i/rdbms/public
-I/archive/newdisk/oracle9i/plsql/public -I/archive/newdisk/oracle
9i/network/public -I/archive/newdisk/oracle9i/rdbms/demo
-I/archive/newdisk/oracle9i/rdbms/demo
-I/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX
_SOURCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O
-DVERSION=\1.12\ -DXS_VERSION=\1.12\ +z
-I/opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE dbdimp.c
cc -c -I/archive/newdisk/oracle9i/rdbms/demo
-I/archive/newdisk/oracle9i/rdbms/public
-I/archive/newdisk/oracle9i/plsql/public -I/archive/newdisk/oracle
9i/network/public -I/archive/newdisk/oracle9i/rdbms/demo
-I/archive/newdisk/oracle9i/rdbms/demo
-I/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX
_SOURCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O
-DVERSION=\1.12\ -DXS_VERSION=\1.12\ +z
-I/opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE oci7.c
cc -c -I/archive/newdisk/oracle9i/rdbms/demo
-I/archive/newdisk/oracle9i/rdbms/public
-I/archive/newdisk/oracle9i/plsql/public -I/archive/newdisk/oracle
9i/network/public -I/archive/newdisk/oracle9i/rdbms/demo
-I/archive/newdisk/oracle9i/rdbms/demo
-I/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBI -D_HPUX
_SOURCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -Ae -O
-DVERSION=\1.12\ -DXS_VERSION=\1.12\ +z
-I/opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/CORE oci8.c
cc: oci8.c, line 267: warning 604: Pointers are not assignment-compatible.
Running Mkbootstrap for DBD::Oracle ()
chmod 644 Oracle.bs
rm -f blib/arch/auto/DBD/Oracle/Oracle.sl
LD_RUN_PATH=/archive/newdisk/oracle9i/lib ld -b
+vnocompatwarnings -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o
/archive/newdisk/oracle9i/rdbm
s/lib/defopt.o -o blib/arch/auto/DBD/Oracle/Oracle.sl
-L/archive/newdisk/oracle9i/lib/ -lclntsh -lcl -lrt -lpthread -ldld -lm
-lqsmashr
ld: /archive/newdisk/oracle9i/rdbms/lib/defopt.o: Mismatched ABI. 64-bit PA
object file found in 32-bit link.
*** Error exit code 1
Stop.
*** 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?)
So I did file /archive/newdisk/oracle9i/rdbms/lib/defopt.o
Here are the results
/archive/newdisk/oracle9i/rdbms/lib/defopt.o: ELF-64 relocatable object
file - PA-RISC 2.0 (LP64)
So it is a 64 Bit Object . Does this mean cc is 32 bit ?
I am not sure why i am getting Mismatched ABI. 64-bit PA object file found
in 32-bit link. Or do I need to rebuild Perl with +z flag option ?
Thanks
Much Appreciated your help
Sanjay
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 18, 2002 12:20 PM
To: WAZA, SANJAY (Non-HP-PaloAlto, ex1); [EMAIL PROTECTED]
Cc: GANESAN, MAYA (HP-SantaClara, ex4); RAMAN, SETHU (Non-HP-SantaClara,
ex2)
Subject: Re: DBI Error
On Sun, 18 Aug 2002 13:23:28 -0400 WAZA,SANJAY (Non-HP-PaloAlto,ex1)
[EMAIL PROTECTED] wrote:
I changed the script as you suggested
#!/opt/perl5.6.1/bin/perl -w
use strict;
use DBI;
my $dbh = DBI-connect( 'dbi:Oracle:p1db',
'partner1',
'p1admin',
{
RaiseError = 1,
AutoCommit = 0
}
) || die Database connection not made:
$DBI::errstr;
If I want a custom error message I normally use { PrintError = 0,
RaiseError = 0, AutoCommit = 0 } and then set $dbh - {RaiseError} to 1
after connect(). Otherwise, connect() never returns on error. I normally
use something like Can't connect to $sInst as $sUser, $DBI::errstr\n. It
may not be necessary for you though, since the instance and username have
been added to the RaiseError message in recent versions of DBI.
The Error is still the same .
install_driver(Oracle) failed: Can't load
'/opt/perl5.6.1/lib/site_perl/5.6.1/PA-RISC2.0/auto/DBD/Oracle/Oracle.sl'
for module DBD::Oracle: No such file or dire
ctory at /opt/perl5.6.1/lib/5.6.1/PA-RISC2.0/DynaLoader.pm line 206.
at (eval 1) line 3
Re: DBI Error
Your DBI have error in line 223. check it, may be permition problem.. On 17 Apr 2002 21:08:07 -0500 Aguztyn Garcia-Cruz [EMAIL PROTECTED] wrote: I have Red Hat 7.2 I already Install DBI, DBD::Pg but I get this error Can't locate loadable object for module DBI in @INC (@INC contains: /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_perl/5.6.1/i386-linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at /usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line 223 BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line 223. Someone can help me please Atte. Aguztyn Garcia
RE: DBI Error
Did you install it under the same perl that you are running the script with? If you have two or more perl installs on that machine, that might of been the problem. Make sure you install and use the same one (ie, use full path). Ilya -Original Message- From: Aguztyn Garcia-Cruz To: [EMAIL PROTECTED] Sent: 4/17/02 8:08 PM Subject: DBI Error I have Red Hat 7.2 I already Install DBI, DBD::Pg but I get this error Can't locate loadable object for module DBI in @INC (@INC contains: /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1 /usr/lib/perl5/site_perl/5.6.1/i386-linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at /usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line 223 BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.6.1/i386-linux/DBI.pm line 223. Someone can help me please Atte. Aguztyn Garcia
Re: DBI error
See http://www.gossamer-threads.com/forum/Products_C9/Gossamer_Mail_C3/Gossamer_Mail_Discussion_F11/DBI_Confusion_P151183/ for one discussion of a similar error message. (Otherwise have you loaded Apache::DBI before DBI in your config/startup files? If not you may have problems?) HTH Henry --- Wolfgang Schwurack [EMAIL PROTECTED] wrote: Has anyone seen this error and if so how can the problem be corrected OS = Solaris Database = Mysql Can't locate object method connect via package Apache::DBI at /opt/gnu/perl5.005_03/lib/site_perl/5.005/sun4-solaris-thread/DBI.pm line 416. Thanks -- Wolfgang Schwurack Unix System Administrator University of Utah/Utah Education Network Tel: (801) 587-9444 __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com
RE: DBI error on Solaris x86
Found this in the DBI docs... --- If you get an error like fatal: relocation error: symbol not found: using gcc 3.x then try not using GNU as or GNU ld on Solaris. I will try some other version of ld. -- steve -Original Message- From: Stephen Gill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:18 AM To: '[EMAIL PROTECTED]' Subject: DBI error on Solaris x86 Importance: High Hi All, I've gone through the process of installing demarc, a front end for snort IDS and have it running with apache + mod_ssl + mod_perl on port 443 on my Solaris x86 server. However, when I attempt an https connection to the server, I get the following error message in my apache error log file: [Tue Mar 5 18:25:15 2002] [error] Can't load '/usr/local/lib/perl5/site_perl/5.005/i86pc-solaris/auto/DBI/DBI.so' for module DBI: ld.so.1: /usr/local/www/bin/httpd: fatal: relocation error: file /usr/local/lib/perl5/site_perl/5.005/i86pc-solaris/auto/DBI/DBI.so: symbol main: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at /usr/local/lib/perl5/site_perl/5.005/i86pc-solaris/DBI.pm line 223 BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.005/i86pc-solaris/DBI.pm line 223. BEGIN failed--compilation aborted at /usr/local/demarc/cgi/demarc line 70. I've installed the latest DBD::Mysql and DBI. I'm running the following versions of programs: Solaris 2.7 x86 mysql-3.23.49 DBD-mysql-2.1011 DBI-1.21 Msql-Mysql-modules-1.2219 apache_1.3.23 mod_ssl-2.8.7-1.3.23 mod_perl-1.26 gcc-2.95.2 Perl 5.005_03 Any hints on what might be the issue? I'm running out of options... Thanks! -- steve A make test with DBD also fails miserably, though I've installed it anyways. make test PERL_DL_NONLAZY=1 /bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.00503/i86pc-solaris -I/usr/local/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/10dsnlist.install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/10dsnlist.t line 45 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-3 Failed 3/3 tests, 0.00% okay t/20createdrop..install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/20createdrop.t line 45 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-5 Failed 5/5 tests, 0.00% okay t/30insertfetch.install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/30insertfetch.t line 48 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/40bindparam...install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 3) line 3 Perhaps a required shared library or dll isn't installed where expected at t/40bindparam.t line 64 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-28 Failed 28/28 tests, 0.00% okay t/40blobs...install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal:
RE: DBI error on Solaris x86
Using a non-GNU ld does not seem to fix the problem. Still getting the same errors. Any ideas? (/usr/ucb/ld). -- steve -Original Message- From: Stephen Gill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:21 AM To: 'Stephen Gill'; '[EMAIL PROTECTED]' Subject: RE: DBI error on Solaris x86 Found this in the DBI docs... --- If you get an error like fatal: relocation error: symbol not found: using gcc 3.x then try not using GNU as or GNU ld on Solaris. I will try some other version of ld. -- steve -Original Message- From: Stephen Gill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:18 AM To: '[EMAIL PROTECTED]' Subject: DBI error on Solaris x86 Importance: High Hi All, I've gone through the process of installing demarc, a front end for snort IDS and have it running with apache + mod_ssl + mod_perl on port 443 on my Solaris x86 server. However, when I attempt an https connection to the server, I get the following error message in my apache error log file: [Tue Mar 5 18:25:15 2002] [error] Can't load '/usr/local/lib/perl5/site_perl/5.005/i86pc-solaris/auto/DBI/DBI.so' for module DBI: ld.so.1: /usr/local/www/bin/httpd: fatal: relocation error: file /usr/local/lib/perl5/site_perl/5.005/i86pc-solaris/auto/DBI/DBI.so: symbol main: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at /usr/local/lib/perl5/site_perl/5.005/i86pc-solaris/DBI.pm line 223 BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.005/i86pc-solaris/DBI.pm line 223. BEGIN failed--compilation aborted at /usr/local/demarc/cgi/demarc line 70. I've installed the latest DBD::Mysql and DBI. I'm running the following versions of programs: Solaris 2.7 x86 mysql-3.23.49 DBD-mysql-2.1011 DBI-1.21 Msql-Mysql-modules-1.2219 apache_1.3.23 mod_ssl-2.8.7-1.3.23 mod_perl-1.26 gcc-2.95.2 Perl 5.005_03 Any hints on what might be the issue? I'm running out of options... Thanks! -- steve A make test with DBD also fails miserably, though I've installed it anyways. make test PERL_DL_NONLAZY=1 /bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5.00503/i86pc-solaris -I/usr/local/lib/perl5/5.00503 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/10dsnlist.install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/10dsnlist.t line 45 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-3 Failed 3/3 tests, 0.00% okay t/20createdrop..install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/20createdrop.t line 45 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-5 Failed 5/5 tests, 0.00% okay t/30insertfetch.install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 1) line 3 Perhaps a required shared library or dll isn't installed where expected at t/30insertfetch.t line 48 dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/40bindparam...install_driver(mysql) failed: Can't load 'blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /bin/perl: fatal: relocation error: file blib/arch/auto/DBD/mysql/mysql.so: symbol mysql_store_result: referenced symbol not found at /usr/local/lib/perl5/5.00503/i86pc-solaris/DynaLoader.pm line 169. at (eval 3) line 3 Perhaps a required shared library or dll isn't installed
Re: DBI error on Solaris x86
Using a non-GNU ld does not seem to fix the problem. Still getting the same errors. Any ideas? (/usr/ucb/ld). That should be /usr/ccs/bin/ld. Reading specs from /opt/gnu/lib/gcc-lib/i386-pc-solaris2.7/2.95.3/specs $ gcc -v gcc version 2.95.3 20010315 (release) $ ldd /opt/perl/lib/site_perl/5.005/i86pc-solaris/auto/DBI/DBI.so libc.so.1 = /usr/lib/libc.so.1 libdl.so.1 =/usr/lib/libdl.so.1 Can your gcc build hello world? Did you build your perl from source? John [EMAIL PROTECTED]
Re: DBI error 127 no cc? HELP PLEASE
Michael, You need to compile DBI with the same compiler that compiled your version of Perl. In your case - Sun's cc. Alternatively you could install the package of Perl 5.6 from www.sunfreeware.com (compiled using gcc) and then compile DBI using gcc. (AFAIKR Solaris 8 perl is in /usr/bin, sunfreeware's in /usr/local/bin so they don't clash. Solaris 8 needs /usr/bin/perl for it's own use so don't remove it :-) ) HTH -- MarkT -Michael Novak- wrote: Howdy All. And Thanx for read'en this.. And A real Big thank you in advance for any on that can throw a little bit of help my way! I am having trouble installing the DBI mod on a SunOS 5.8 with perl version 5.005_03 During My Make Cmd I get the following error make: cc: Command not found make: *** [Perl.o] Error 127 My path is $PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/X11R6/bin I tried to make a soft link form /usr/loval/bin/gcc to /usr/local/bin/cc for grins and giggles and no such luck Any Ideas?? Thanks Again! -Michael Novak- [EMAIL PROTECTED] Script started on Thu Jan 03 12:53:59 2002 sh-2.04$ sudo perl Makefile.PL *** Note: The optional PlRPC-modules (RPC::PlServer etc) are not installed. If you want to use the DBD::Proxy driver and DBI::ProxyServer modules, then you'll need to install the RPC::PlServer, RPC::PlClient, Storable and Net::Daemon modules. The CPAN Bundle::DBI may help you. You can install them any time after installing the DBI. You do *not* need these modules for typical DBI usage. Optional modules are available from any CPAN mirror, in particular http://www.perl.com/CPAN/modules/by-module http://www.perl.org/CPAN/modules/by-module ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module Checking if your kit is complete... Looks good Writing Makefile for DBI Remember to actually *read* the README file! Use 'make' to build the software (dmake or nmake on Windows). Then 'make test' to execute self tests. Then 'make install' to install the DBI and then delete this working directory before unpacking and building any DBD::* drivers. sh-2.04$ sudo make mkdir blib mkdir blib/lib mkdir blib/arch mkdir blib/arch/auto mkdir blib/arch/auto/DBI mkdir blib/lib/auto mkdir blib/lib/auto/DBI mkdir blib/man1 mkdir blib/man3 cp lib/DBI/W32ODBC.pm blib/lib/DBI/W32ODBC.pm cp lib/DBD/ExampleP.pm blib/lib/DBD/ExampleP.pm cp lib/DBI/FAQ.pm blib/lib/DBI/FAQ.pm cp lib/DBI/Shell.pm blib/lib/DBI/Shell.pm cp lib/DBI/ProxyServer.pm blib/lib/DBI/ProxyServer.pm cp lib/Bundle/DBI.pm blib/lib/Bundle/DBI.pm cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm cp DBIXS.h blib/arch/auto/DBI/DBIXS.h cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h cp dbi_sql.h blib/arch/auto/DBI/dbi_sql.h cp lib/DBD/NullP.pm blib/lib/DBD/NullP.pm cp lib/DBD/Sponge.pm blib/lib/DBD/Sponge.pm cp lib/DBI/Format.pm blib/lib/DBI/Format.pm cp lib/DBI/DBD.pm blib/lib/DBI/DBD.pm cp Driver.xst blib/arch/auto/DBI/Driver.xst cp dbipport.h blib/arch/auto/DBI/dbipport.h cp lib/Win32/DBIODBC.pm blib/lib/Win32/DBIODBC.pm cp DBI.pm blib/lib/DBI.pm /bin/perl -p -e s/~DRIVER~/Perl/g blib/arch/auto/DBI/Driver.xst Perl.xsi /bin/perl -I/usr/perl5/5.00503/sun4-solaris -I/usr/perl5/5.00503 /usr/perl5/5.00503/ExtUtils/xsubpp -typemap /usr/perl5/5.00503/ExtUtils/typemap Perl.xs xstmp.c mv xstmp.c Perl.c cc -c -xO3 -xdepend-DVERSION=\1.20\ -DXS_VERSION=\1.20\ -KPIC -I/usr/perl5/5.00503/sun4-solaris/CORE -DDBI_NO_THREADS Perl.c make: cc: Command not found make: *** [Perl.o] Error 127 sh-2.04$ perl -V Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration: Platform: osname=solaris, osvers=2.8, archname=sun4-solaris uname='sunos localhost 5.8 sun4u sparc sunw,ultra-1 ' hint=previous, useposix=true, d_sigaction=define usethreads=undef useperlio=undef d_sfio=undef Compiler: cc='cc', optimize='-xO3 -xdepend', gccversion= cppflags='' ccflags ='' stdchar='char', d_stdstdio=define, usevfork=false intsize=4, longsize=4, ptrsize=4, doublesize=8 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 alignbytes=8, usemymalloc=n, prototype=define Linker and Libraries: ld='cc', ldflags ='' libpth=/lib /usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc -lcrypt libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-R /usr/perl5/5.00503/sun4-solaris/CORE' cccdlflags='-KPIC', lddlflags='-G' Characteristics of this binary (from libperl): Built under solaris Compiled at Dec 22 1999 00:00:57 @INC: /usr/perl5/5.00503/sun4-solaris
Re: DBI error 127 no cc? HELP PLEASE
On Thu, 3 Jan 2002, -Michael Novak- wrote: Howdy All. And Thanx for read'en this.. And A real Big thank you in advance for any on that can throw a little bit of help my way! I am having trouble installing the DBI mod on a SunOS 5.8 with perl version 5.005_03 During My Make Cmd I get the following error make: cc: Command not found make: *** [Perl.o] Error 127 My path is $PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/X11R6/bin I tried to make a soft link form /usr/loval/bin/gcc to /usr/local/bin/cc for grins and giggles and no such luck If you have Sun Workshop, make sure that /opt/SUNWspro/bin is in your path and you can use Sun's CC. Also make sure that your PATH is exported, and double-check your symlink to make sure it's pointed correctly if you are using GCC. - D [EMAIL PROTECTED]
RE: DBI error 127 no cc? HELP PLEASE
First, you need to build your own perl... (using the version delivered with the OS almost never works, unless of have exactly the same cc that the OS vender used). You need to have either, some flavor of (ansi) cc or gcc to do it. I am about to do this on Sun0S 5.8 in the next few days... using gcc from the sun freeware cd. (and perl 5.6.1). If you can wait I'll let you know what the recipe is... toward the end of next week. Lincoln -Original Message- From: -Michael Novak- [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 4:07 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: DBI error 127 no cc? HELP PLEASE Howdy All. And Thanx for read'en this.. And A real Big thank you in advance for any on that can throw a little bit of help my way! I am having trouble installing the DBI mod on a SunOS 5.8 with perl version 5.005_03 During My Make Cmd I get the following error make: cc: Command not found make: *** [Perl.o] Error 127 My path is $PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/X11R6/bin I tried to make a soft link form /usr/loval/bin/gcc to /usr/local/bin/cc for grins and giggles and no such luck Any Ideas?? Thanks Again! -Michael Novak- [EMAIL PROTECTED]
Re: dbi error
Godoli Davide wrote: Ok, now I've already installed DBI-1_20 on my system, and when try to install DBD::ODBC I get: Did you really install DBI as well as DBD::ODBC? Try this: D:\perl -MDBI -e print $DBI::VERSION; 1.20 If you get: Can't locate DBI.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/5.6.1/lib/MSW in32-x86-multi-thread C:/Perl/site/5.6.1/lib C:/Perl/site/lib .). BEGIN failed--compilation aborted. Then there's something wrong with your DBI installtion. If I was you: ppm remove DBI DBD::ODBC ppm install DBI DBD::ODBC -- Simon Oliver
RE: DBI error expected but didn't get any
): FLAGS 0x191: COMSET Warn RaiseError PrintError TYPE 2 PARENT DBI::dr=HASH(0x40035d1c) KIDS 0 (0 active) IMP_DATA undef in 'DBD::Oracle::db' dbih_clearcom 0x40248170 (com 0x40036c08, type 2) done. - DBI::END disconnect_all DISPATCH (DBI::dr=HASH(0x40175714) rc1/3 @1 g0 a401b2fe8) at /var/tools/lib/perl5/PA-RISC1.1/DBI.pm line 424. - disconnect_all for DBD::Oracle::dr (DBI::dr=HASH(0x40175714)~0x40035d1c) - disconnect_all= '' at /var/tools/lib/perl5/PA-RISC1.1/DBI.pm line 424. - DBI::END complete DESTROY DISPATCH (DBI::dr=HASH(0x40035d1c) rc1/1 @1 g0 a0) during global destruction. - DESTROY in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0x40035d1c)~INNER) - DESTROY= undef during global destruction. dbih_clearcom (h 0x40175714, com 0x4003c088): FLAGS 0x215: COMSET Active Warn AutoCommit TYPE 1 PARENT undef KIDS 0 (0 active) IMP_DATA undef in 'DBD::Oracle::dr' dbih_clearcom 0x40175714 (com 0x4003c088, type 1) done. DESTROY DISPATCH (DBI::dr=HASH(0x40175714) rc1/1 @1 g0 a0) during global destruction. DESTROY for DBI::dr=HASH(0x40175714) ignored (inner handle gone) --- Frans Postma, (050-58) 81 852 KPN Datacenter, SDU Unix Support -Oorspronkelijk bericht- Van: Tim Bunce [mailto:[EMAIL PROTECTED]] Verzonden: vrijdag 1 juni 2001 11:24 Aan: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Onderwerp: Re: DBI error expected but didn't get any First try rebuilding DBD::Oracle if it wasn't built for the version of Oracle you're talking to. If that doesn't help then talk to Oracle about it. Don't mention the DBI, just talk about your 'Oracle OCI application' :) On the upside, it seems that it does say 0 rows updated :) Tim. On Fri, Jun 01, 2001 at 10:52:59AM +0200, [EMAIL PROTECTED] wrote: Hi, I'm using DBI 1.16 with DBD:Oracle 1.06 , the following line does NOT give me an error, while the same code DOES give an error (as it should) when run through sqlplus: update DC_PATROL_STATUS_TABLE set SEVERITY='OK',date_inserted=sysdate,escalation_id='*NONE*', MESSAGE='Reset from GUI by user: user',TIMESTAMP=991379859000 where SYSTEM_NAME='hdxh20' and MODULE='KPN_Log' and INSTANCE='-tmp-logfile1_txt' and (PARAMETER = 'Msg' or PARAMETER = 'OldMsg'); The point is that the value for SEVERITY is too large for the column, which oracle sqlplus reports as: update DC_PATROL_STATUS_TABLE set SEVERITY='OK',date_inserted=sysdate,escalation_id='*NONE*', * ERROR at line 1: ORA-01401: inserted value too large for column My question is: why does the $dbh-do() I issue the same command with using DBI/DBD not return an error?? (RaiseError = 1, PrintError = 1) Oracle version is 8.1.7. OS = HPUX 11.00 ** Trace with level 7 and perl -V output appended: DBI 1.16-nothread dispatch trace level set to 7 Note: perl is running without the recommended perl -w option - do in DBD::_::db for DBD::Oracle::db (DBI::db=HASH(0x402406c0)~0x4023a7ec 'update DC_PATROL_STATUS_TABLE set SEVERITY='OK',date_inserted=sysdate,escalation_id='*NONE*', MESSAGE='Reset from GUI by user: patrolAgent',TIMESTAMP=99138546 where SYSTEM_NAME='hdxh20' and MODULE='KPN_Log' and INSTANCE='KPN_Log' and (PARAMETER = 'Msg' or PARAMETER = 'OldMsg')') 2 - prepare for DBD::Oracle::db (DBI::db=HASH(0x4023a7ec)~INNER 'update DC_PATROL_STATUS_TABLE set SEVERITY='OK',date_inserted=sysdate,escalation_id='*NONE*', MESSAGE='Reset from GUI by user: patrolAgent',TIMESTAMP=99138546 where SYSTEM_NAME='hdxh20' and MODULE='KPN_Log' and INSTANCE='KPN_Log' and (PARAMETER = 'Msg' or PARAMETER = 'OldMsg')' undef) New DBI::st (for DBD::Oracle::st, parent=DBI::db=HASH(0x4023a7ec), id=) dbih_setup_handle(DBI::st=HASH(0x4024072c)=DBI::st=HASH(0x401f791c), DBD::Oracle::st, 40240774, Null!) dbih_make_com(DBI::db=HASH(0x4023a7ec), DBD::Oracle::st, 204) dbih_setup_attrib(DBI::st=HASH(0x401f791c), Err, DBI::db=HASH(0x4023a7ec)) SCALAR(0x40242da0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x401f791c), State, DBI::db=HASH(0x4023a7ec)) SCALAR(0x4018def0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x401f791c), Errstr, DBI::db=HASH(0x4023a7ec)) SCALAR(0x40242dc4) (already defined) dbih_setup_attrib(DBI::st=HASH(0x401f791c), Handlers, DBI::db=HASH(0x4023a7ec)) ARRAY(0x4026e2fc) (already defined) dbih_setup_attrib(DBI::st=HASH(0x401f791c), Debug, DBI::db=HASH(0x4023a7ec)) 0 (already defined) OCIHandleAlloc(4002d6b8,40227084,4,0,)=SUCCESS OCIStmtPrepare(4028d920,4003eb30,'update DC_PATROL_STATUS_TABLE set SEVERITY='OK',date_inserted=sysdate
Re: DBI error expected but didn't get any
On Fri, Jun 01, 2001 at 12:18:55PM +0200, [EMAIL PROTECTED] wrote: Tim, Is my assumption correct that either: OCIStmtPrepare or OCIStmtExecute should return an error of some sort ?? I'd expect OCIStmtExecute to return OCI_ERROR or OCI_SUCCESS_WITH_INFO. But since the update says it updated 0 rows perhaps the problem lies there. I.e., the where clause didn't match (for whatever obscure reason, maybe charset issues) so Oracle never got to the point of discovering it would need to truncate the field. I did rebuild DBD on the same machine against Oracle 8.1.7. yesterday. We have pretty much all versions of Oracle over here, so I tried it on Oracle 7.3.4. (hpux10.20, same perl).. got the same result. Would that mean that there's a never-found bug in OCI ?? (kinda hard to believe it has persisted for so long) Indeed. Output is below, note that that server is a production/HA-server so I can't install DBI 1.16 without testing it extensivly. That's would be relevant. Tim.
