Hi list,I was able to install DBI module but DBD is giving the following error:C:\download\dbd1>ppm install DBD-Oracle Error: PPD for 'DBD-Oracle.ppd' could not be found. What am I missing? Thanks in advance
--------------------------------- Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo.
$mmk test perl5_6_1 "-I[.blib.arch]" "-I[.blib.lib]" "-Iperl_rootlib]" "-Iperl_rootlib.VMS_AXP.5_6_1]" -e "use Test::Harness qw(&runtests $verbose); $verbose=0 ; runtests @ARGV;" t/*.t t/basics............ ok t/dbidrv............ ok t/examp............. # failed test 153 at line 376 # failed test 154 at line 389 FAILED tests 153-154 Failed 2/175 tests, 98.86% okay t/meta.............. ok t/preparse.......... ok t/proxy............. skipped test on this platform t/shell............. DBI::Shell 11.02 using DBI 1.20 in batch mode ok t/subclass.......... ok Failed Test Status Wstat Total Fail Failed List of Failed ---------------------------------------------------------------------------- ---- t/examp.t 175 2 1.14% 153-154 1 test skipped. Failed 1/8 test scripts, 87.50% okay. 2/240 subtests failed, 99.17% okay. %SYSTEM-F-ABORT, abort %MMK-F-ERRUPD, error status %X0000002C occurred when updating target TEST_DYNAMIC
Characteristics of this PERLSHR image: Compile-time options: DEBUGGING Built under VMS Compiled at Aug 16 2001 15:46:23 %ENV: PERLLIB="PERL_ROOT:[LIB]" PERLSHR="$4$DUA1PERL-5_6_1]PERLSHR.EXE" PERL_ROOT="$4$DUA1:[PERL-5_6_1.]" @INC: PERL_ROOTLIB] perl_rootlib.VMS_AXP.5_6_1] perl_rootlib] perl_rootlib.site_perl.VMS_AXP] perl_rootlib.site_perl] /perl_root/lib/site_perl .
Craig A. Berry 28 November 2001 23:20:50 [ permanent link ]
At 12:33 PM 11/28/2001 -0500, Bunders, Charles L. wrote:>I have installed the pre-built binary from http://www.sidhe.org/vmsperl/. I>am running Perl version 5.6.1 on VMS version 7.2-1.>
This version of Perl has DBI v1.19 installed right away. I try and install>DBD-Oracle v1.12 and it says it needs > DBI v1.19.>
I have seen this go around before where people had trouble with this and>thought maybe someone on this list who got it to work could help me out.>
The initial install of DBI 1.20 goes like this -
<snip>
Link /NoTrace/NoMap /Shareable=[.BLIB.ARCH.AUTO.DBI]PL_DBI.EXE>DBI.opt/Option,perl_rootlib.VMS_AXP.5_6_1.CORE]perlshr_attr.opt/Option>%LINK-I-OPENIN, error opening $4$DUA44BCA.BCADOSA120.LIBRARY]DOSLIB.OLB;>as input>-RMS-E-FNF, file not found
Something's amiss here. I just tried DBI 1.20 with Perl 5.6.1 on OpenVMS Alpha v7.1 and had no trouble getting it to build. Any idea what DOSLIB is? Try this
$ pipe show logical * | search sys$input doslib
and see if you have some logical name leading you astray. My dbi.opt looks like this and yours should too:
$ type dbi.opt SYMBOL_VECTOR=(boot_DBI=PROCEDURE) [.blib.arch.auto.DBI]DBI.olb/Include=DBI [.blib.arch.auto.DBI]DBI.olb/Library PerlShr/Share $
Mustafa Ocak 23 September 2003 13:42:11 [ permanent link ]
Hello
When I try to execute a script from the command line here are the messages I get:
hpcd03[/www/ca/docs/cgi-bin]$ perl report.pl /usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage: /usr/lib/libcl.2 /usr/lib/dld.sl: Exec format error Can't load '/opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/auto/DBD/Oracle/O racl e.sl' for module DBD::Oracle: Exec format error at /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/DynaLoader.pm line 206. Compilation failed in require at report.pl line 5. BEGIN failed--compilation aborted at report.pl line 5.
/usr/lib/dld.sl: Can't shl_load() a library containing Thread Local Storage: /usr/lib/libcl.2 /usr/lib/dld.sl: Exec format error install_driver(Oracle) failed: Can't load '/opt/perl/lib/site_perl/5.6.1/PA-RISC1.1-thread-multi/auto/DBD/Oracle/O racl e.sl' for module DBD::Oracle: Exec format error at /opt/perl/lib/5.6.1/PA-RISC1.1-thread-multi/DynaLoader.pm line 206.
Do you have any thoughts on what the problem could be?
James Hooker 1 December 2003 21:23:33 [ permanent link ]
I have upgraded to Perl v5.8.1 and now my DBD::Oracle module doesn't work for this version. Where can I get the Oracle database driver for this version.
James C. Hooker Marconi - TAC 1755 N. Collins Suite 400 Richardson, TX 75080 mobile: 214.498.9634 office: 972.669.6323 Please send all Technical Support requests to: support.wireless@marconi.com <mailto:support.wireless@marconi.com> or call 1-877-777-7441 For support information, software updates and FAQ's please visit our support website at: http://www.marconi.com/html/products/wnpproductsupport.htm
Jeff Griffiths 1 December 2003 21:35:28 [ permanent link ]
what did you upgrade from?
James Hooker wrote:> I have upgraded to Perl v5.8.1 and now my DBD::Oracle module doesn't work> for this version. Where can I get the Oracle database driver for this> version. >
James C. Hooker> Marconi - TAC> 1755 N. Collins> Suite 400> Richardson, TX 75080> mobile: 214.498.9634> office: 972.669.6323> Please send all Technical Support requests to: support.wireless@marconi.com> <mailto:support.wireless@marconi.com> or call 1-877-777-7441> For support information, software updates and FAQ's please visit our support> website at: http://www.marconi.com/html/products/wnpproductsupport.htm>
Jeff Griffiths 1 December 2003 23:31:29 [ permanent link ]
oops posted this to the wrong list =)
Jeff Griffiths wrote:> modules compiled for 5.6.x are not binary compatible with Perl 5.8.x, > and vice versa. even more fun, ActiveState is currently not allowed to > compile DBD::Oracle due to restrictions in Oracle's licensing scheme.>
if you're on Windows, the path of least resistance is to use DBD::ODBC > or DBD::ADO as long as you're comfortable taking a bit of a performance > hit. there are rumors that some Oracle products bundle DBD::Oracle - I > don't have solid info on that as ActiveState is not an Oracle customer.>
the situation in general is fairly bad IMO as connectivity between Perl > and Oracle seems to be something a lot of people want to do. I have > talked to Tim Bunce a bit about this and I believe he is trying to > convince Oracle to change their licensing in order to allow us to > compile using their client libraries and redistribute the ( dynamically > linked ) result.>
regards, JeffG>
James Hooker wrote:>
I think it was Perl 5.6.1.>> James C. Hooker>> Marconi - TAC>> 1755 N. Collins>> Suite 400>> Richardson, TX 75080>> mobile: 214.498.9634>> office: 972.669.6323>> Please send all Technical Support requests to: >> support.wireless@marconi.com>> <mailto:support.wireless@marconi.com> or call 1-877-777-7441>> For support information, software updates and FAQ's please visit our >> support>> website at: http://www.marconi.com/html/products/wnpproductsupport.htm>>
-----Original Message----->> From: Jeff Griffiths [mailto:jeffg@ActiveState.com]>> Sent: Monday, December 01, 2003 12:35 PM>> To: James Hooker>> Cc: 'activeperl@listserv.ActiveState.com'>> Subject: Re: DBD::Oracle>>
what did you upgrade from?>>
James Hooker wrote:>>
I have upgraded to Perl v5.8.1 and now my DBD::Oracle module doesn't >>> work>>> for this version. Where can I get the Oracle database driver for this>>> version.>>> James C. Hooker>>> Marconi - TAC>>> 1755 N. Collins>>> Suite 400>>> Richardson, TX 75080>>> mobile: 214.498.9634>>> office: 972.669.6323>>> Please send all Technical Support requests to:>>
support.wireless@marconi.com>>
<mailto:support.wireless@marconi.com> or call 1-877-777-7441>>> For support information, software updates and FAQ's please visit our>>
Using CPAN DBI installs fine, but when I try to install DBD::Oracle I get the following:
WARNING: could not decode oracle version from /Users/oracle/9iR2/orahome/orainst/inspdver, or /Users/oracle/9iR2/orahome/install/unix.rgs or from ORACLE_HOME path /Users/oracle/9iR2/orahome. Oracle version based logic in Makefile.PL may produce erroneous results.
ERROR: symbol table needs modification in Oracle library: /Users/oracle/9iR2/orahome/lib/libclntsh.dylib.9.0
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x3f05b8)~INNER)
! <- DESTROY= (not implemented) during global destruction
! -> DESTROY in DBD::File::dr for DBD::CSV::dr (DBI::dr=HASH(0x3c7750)~INNER)
! <- DESTROY= undef during global destruction
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
I'm no expert on DBD::CSV, but it looks like the ordering of your columns in your select list is not mapping correctly to the format of your input file. The key to this is located in the DBI trace log. Look for "[Ron Reidy]" below:
----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Robert [mailto:rgoud@yahoo.com] Sent: Thursday, September 30, 2004 11:23 AM To: DBI-Users Subject: DBD-Oracle
Hi list, I am trying to load the following data into Oracle table which has a date column
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
[Ron Reidy] According to your input data (and how you are binding this data), column #2 should be the date/time data. Because this data is not numeric, it is throwing the ORA-01858 error.
! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x3f05b8)~INNER)
! <- DESTROY= (not implemented) during global destruction
! -> DESTROY in DBD::File::dr for DBD::CSV::dr (DBI::dr=HASH(0x3c7750)~INNER)
! <- DESTROY= undef during global destruction
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
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.
Changing the order did not help, I am still getting same error.
"Reidy, Ron" <Ron.Reidy@arraybiopharma.com> wrote:I'm no expert on DBD::CSV, but it looks like the ordering of your columns in your select list is not mapping correctly to the format of your input file. The key to this is located in the DBI trace log. Look for "[Ron Reidy]" below:
----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Robert [mailto:rgoud@yahoo.com] Sent: Thursday, September 30, 2004 11:23 AM To: DBI-Users Subject: DBD-Oracle
Hi list, I am trying to load the following data into Oracle table which has a date column
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
[Ron Reidy] According to your input data (and how you are binding this data), column #2 should be the date/time data. Because this data is not numeric, it is throwing the ORA-01858 error.
! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x3f05b8)~INNER)
! <- DESTROY= (not implemented) during global destruction
! -> DESTROY in DBD::File::dr for DBD::CSV::dr (DBI::dr=HASH(0x3c7750)~INNER)
! <- DESTROY= undef during global destruction
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
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.
--------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages!
I'm no expert on DBD::CSV, but it looks like the ordering of your columns in your select list is not mapping correctly to the format of your input file. The key to this is located in the DBI trace log. Look for "[Ron Reidy]" below:
----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Robert [mailto:rgoud@yahoo.com] Sent: Thursday, September 30, 2004 11:23 AM To: DBI-Users Subject: DBD-Oracle
Hi list, I am trying to load the following data into Oracle table which has a date column
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (! DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
!! ERROR: 1858 'ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute)' (err#0) <- execute= undef at DBI.pm line 1428
!! ERROR: 1858 'ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute)' (err#0)
[Ron Reidy] According to your ! input data (and how you are binding this data), column #2 should be the date/time data. Because this data is not numeric, it is throwing the ORA-01858 error.
! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x3f05b8)~INNER)
! <- DESTROY= (not implemented) during global destruction
! -> DESTROY in DBD::File::dr for DBD::CSV::dr (DBI::dr=HASH(0x3c7750)~INNER)
! <- DESTROY= undef during global destruction
__________________________________________________ Do You Yahoo!? Tired of spam? Yaho! o! Mail has the best spam protection around http://mail.yahoo.com
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.
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.
I'm no expert on DBD::CSV, but it looks like the ordering of your columns in your select list is not mapping correctly to the format of your input file. The key to this is located in the DBI trace log. Look for "[Ron Reidy]" below:
----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Robert [mailto:rgoud@yahoo.com] Sent: Thursday, September 30, 2004 11:23 AM To: DBI-Users Subject: DBD-Oracle
Hi list, I am trying to load the following data into Oracle table which has a date column
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (! DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
!! ERROR: 1858 'ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute)' (err#0) <- execute= undef at DBI.pm line 1428
!! ERROR: 1858 'ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute)' (err#0)
[Ron Reidy] According to your ! input data (and how you are binding this data), column #2 should be the date/time data. Because this data is not numeric, it is throwing the ORA-01858 error.
! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x3f05b8)~INNER)
! <- DESTROY= (not implemented) during global destruction
! -> DESTROY in DBD::File::dr for DBD::CSV::dr (DBI::dr=HASH(0x3c7750)~INNER)
! <- DESTROY= undef during global destruction
__________________________________________________ Do You Yahoo!? Tired of spam? Yaho! o! Mail has the best spam protection around http://mail.yahoo.com
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.
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.
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.
I'm no expert on DBD::CSV, but it looks like the ordering of your columns in your select list is not mapping correctly to the format of your input file. The key to this is located in the DBI trace log. Look for "[Ron Reidy]" below:
----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Robert [mailto:rgoud@yahoo.com] Sent: Thursday, September 30, 2004 11:23 AM To: DBI-Users Subject: DBD-Oracle
Hi list, I am trying to load the following data into Oracle table which has a date column
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (! DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
DBD::Oracle::db do failed: ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute) [for Statement "INSERT INTO webtest (hostname,datetime,url,username,company) VALUES ( ?, TO_DATE(?,'DD/Mon/YYYY:HH24:MI:SS'), ?, ?, ? )"] at test4.pl line 34.
!! ERROR: 1858 'ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute)' (err#0) <- execute= undef at DBI.pm line 1428
!! ERROR: 1858 'ORA-01858: a non-numeric character was found where a numeric was expected (DBD ERROR: OCIStmtExecute)' (err#0)
[Ron Reidy] According to your ! input data (and how you are binding this data), column #2 should be the date/time data. Because this data is not numeric, it is throwing the ORA-01858 error.
! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x3f05b8)~INNER)
! <- DESTROY= (not implemented) during global destruction
! -> DESTROY in DBD::File::dr for DBD::CSV::dr (DBI::dr=HASH(0x3c7750)~INNER)
! <- DESTROY= undef during global destruction
__________________________________________________ Do You Yahoo!? Tired of spam? Yaho! o! Mail has the best spam protection around http://mail.yahoo.com
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.
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.
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.
Now when I execute make I get the following error: [root@recover DBD-Oracle-1.16]# make gcc -c -D_REENTRANT -D_GNU_SOURCE -DTHREADS_HAVE_PIDS -DDEBUGGING -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -DVERSION=\"\" -DXS_VERSION=\"\" -fPIC "-I/usr/lib/perl5/5.8.0/ia64-linux-thread-multi/CORE" Oracle.c Oracle.xs: In function `XS_DBD__Oracle_ORA_OCI': Oracle.xs:43: `ORA_OCI_VERSION' undeclared (first use in this function) Oracle.xs:43: (Each undeclared identifier is reported only once Oracle.xs:43: for each function it appears in.) make: *** [Oracle.o] Error 1 Thanks...
-- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.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.
Error: No valid repositories: Error: 500 Can't connect to proxy:80 (Bad hostname 'proxy') Error: 500 Can't connect to proxy:80 (Bad hostname 'proxy')ppm>
Thank You
Best Regards, Satish EngineerВ-Advanced Solutions
-----Original Message----- From: Michael A Chase tech [mailto:mchase@ix.netcom.com] Sent: Monday, January 17, 2005 2:39 AM To: Waghmare, Satish (IE03x) Cc: dbi-users@perl.org Subject: Re: DBD::Oracle
On 01/17/2005 05:02 AM, Waghmare, Satish (IE03x) said:
Send me the PPM package for DBD::Oracle. Activestate 5.8
-- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.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.
If you need to use a proxy server, set the environment variables to point to that server instead of "proxy:80". If you are connected directly to the internet, remove the applicable environment variables from your system.
-- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.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.
On Tue, Mar 22, 2005 at 01:52:10PM -0800, Greg Fossheim wrote:> Has anyone built DBD::Oracle with the instantclient libraries? (v. 10.0.> specifically)>
Would greatly appreciate any feedback available,
Some have and reported here. Try google.
I hope to get aroundtuit sometime soonish to add explicit support for instantclient in DBD::Oracle. It's top of my list for DBD::Oracle.
Christian Braeuner 11 April 2005 22:19:28 [ permanent link ]
Dear perl dbi team,
I need a windows binary for the DBD-Oracle, but it seems the esoftmatic link is invalid. Do you know any different sources or whether the esoftmatic is only temporarily unavailable?
Please, temporarily, change ftp.esoftmatic.com to 24.249.249.7. I'm still working on resolving the DNS issues since moving ISPs and my current ISP is relatively deaf. I probably have to bit the bullett and put DNS on my server(s), which I'm not thrilled about ;)
Jeff
-----Original Message-----> From: Christian Braeuner [mailto:christian.braeuner@gmx.net] > Sent: Monday, April 11, 2005 2:19 PM> To: dbi-users@perl.org> Subject: DBD-Oracle>
Dear perl dbi team,>
I need a windows binary for the DBD-Oracle, but it seems the > esoftmatic > link is invalid. Do you know any different sources or whether the > esoftmatic is only temporarily unavailable?>
Christian Braeuner 12 April 2005 11:40:08 [ permanent link ]
Hi Jeff,
Thanks for the quick response!
Christian
Jeff Urlwin wrote:
Please, temporarily, change ftp.esoftmatic.com to 24.249.249.7. I'm still working on>resolving the DNS issues since moving ISPs and my current ISP is relatively deaf. I>probably have to bit the bullett and put DNS on my server(s), which I'm not thrilled about>;)>
Jeff>
-----Original Message----->>From: Christian Braeuner [mailto:christian.braeuner@gmx.net] >>Sent: Monday, April 11, 2005 2:19 PM>>To: dbi-users@perl.org>>Subject: DBD-Oracle>>
Dear perl dbi team,>>
I need a windows binary for the DBD-Oracle, but it seems the >>esoftmatic >>link is invalid. Do you know any different sources or whether the >>esoftmatic is only temporarily unavailable?>>
Is your site down, I am trying to get the above module. Can you please redirect me to a place were i can get it, i am trying to use the ppm utility because compiling in windows is a headache.
I just answered this a day or two ago. Please use 24.249.249.7 as the IP instead of ftp.esoftmatic.com until I get my ISP to respond to the DNS needs.
Thanks,
Jeff
-----Original Message-----> From: Ramesh Patel [mailto:ramzey1981@gmail.com] > Sent: Wednesday, April 13, 2005 1:33 PM> To: dbi-users@perl.org> Subject: DBD-Oracle>
hello, >
Is your site down, I am trying to get the above module. Can > you please redirect me to a place were i can get it, i am > trying to use the ppm utility because compiling in windows is > a headache.>
Is there any way that i could download DBD-Oracle.ppd for perl 5.8.7(or 5.8.4) version on windows XP.
thanks, Mary.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Is there any way that i could download DBD-Oracle.ppd for perl 5.8.7(or 5.8.4) version on windows XP.
thanks, Mary.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
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.
Is there any way that i could download DBD-Oracle.ppd for perl 5.8.7(or 5.8.4) version on windows XP.
thanks, Mary.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
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.
--------------------------------- Start your day with Yahoo! - make it your home page
12560, 00000, "TNSrotocol adapter error" // *Cause: A generic protocol adapter error occurred. // *Action: Check addresses used for proper protocol specification. Before // reporting this error, look at the error stack and check for lower level // transport errors.For further details, turn on tracing and reexecute the // operation. Turn off tracing when the operation is complete.
Can you tnsping the DB instance you are attempting to connect to in your Perl program?
If not, consult with your DBA.
----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Mary [mailto:m_w_24@yahoo.com] Sent: Monday, July 25, 2005 6:58 AM To: Reidy, Ron; dbi-users@perl.org Subject: RE: DBD-Oracle
I could able to download it now. Thanks!
when i am trying to run my perl script i am getting this error:
Is there any way that i could download DBD-Oracle.ppd for perl 5.8.7(or 5.8.4) version on windows XP.
thanks, Mary.
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileg! ed. 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.
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.
-----Original Message----- From: David Sawyer [mailtoSawyer@Ceon.com] Sent: Friday, October 21, 2005 9:01 AM To: dbi-users@perl.org Subject: DBD-Oracle
I am desperately trying to install DBD-Oracle on my UNIX system. No matter what I try I get the error :
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.
-----Original Message----- From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com] Sent: Friday, October 21, 2005 9:50 AM To: David Sawyer; dbi-users@perl.org Subject: RE: DBD-Oracle
So, I just have to ask ...
Is your Perl from AS?
-- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: David Sawyer [mailtoSawyer@Ceon.com] Sent: Friday, October 21, 2005 9:01 AM To: dbi-users@perl.org Subject: DBD-Oracle
I am desperately trying to install DBD-Oracle on my UNIX system. No matter what I try I get the error :
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.
OK. I do not believe there exists a PPM for DBD::Oracle after version 5.6.1 from AS. Supposedly, because of licensing issues.
The next step would be to build DBD::Oraacle yourself. You will need the same C compiler iused to build Perl.
-- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: David Sawyer [mailtoSawyer@Ceon.com] Sent: Friday, October 21, 2005 11:01 AM To: Reidy, Ron; dbi-users@perl.org Subject: RE: DBD-Oracle
Yes. It's Activate State v5.8.7 for Sun multi-thread
-----Original Message----- From: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com] Sent: Friday, October 21, 2005 9:50 AM To: David Sawyer; dbi-users@perl.org Subject: RE: DBD-Oracle
So, I just have to ask ...
Is your Perl from AS?
-- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: David Sawyer [mailtoSawyer@Ceon.com] Sent: Friday, October 21, 2005 9:01 AM To: dbi-users@perl.org Subject: DBD-Oracle
I am desperately trying to install DBD-Oracle on my UNIX system. No matter what I try I get the error :
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.
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.
Piet Paaltjens 17 November 2005 00:01:02 [ permanent link ]
Dear Jay,
some time ago you've helped me to try and get Oracleinstantclient 10.2 to work on my machine. You even sent me your installed software. For me, alas, it did not work. Just to let you know, recently I've found info about how to install Oracle 9 and/or 10 on Fedora Core. Now I've got my system running as it did some time ago. Thanks alot for your effort(s).
--------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.
Jay Strauss 17 November 2005 16:20:08 [ permanent link ]
On Wednesday 16 November 2005 3:01 pm, piet paaltjens wrote:> Dear Jay,>
some time ago you've helped me to try and get Oracleinstantclient 10.2 > to work on my machine. You even sent me your installed software. For me,> alas, it did not work. Just to let you know, recently I've found info> about how to install Oracle 9 and/or 10 on Fedora Core. Now I've got my> system running as it did some time ago. Thanks alot for your effort(s).
I'm glad you got it working. I'm sorry I couldn't be more help. Have fun using DBD::Oracle
Maniace Libi - lmania 11 April 2006 20:09:01 [ permanent link ]
I have a developer who wants DBD::ORACLE installed on a Solaris server. There is not an instance of
Oracle installed on this server. He is certain that it can be installed, but I can't find information supporting
this. It always errors out with wanting "Oracle_home". Is there a way to install DBD without oracle
installed.
Thanks
Libi
*************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Scott T. Hildreth 11 April 2006 20:27:39 [ permanent link ]
On Tue, 2006-04-11 at 11:09 -0500, Maniace Libi - lmania wrote:> I have a developer who wants DBD::ORACLE installed on a Solaris server.> There is not an instance of>
Oracle installed on this server. He is certain that it can be installed,> but I can't find information supporting>
this. It always errors out with wanting "Oracle_home". Is there a way to> install DBD without oracle
You would need an Oracle Client installed, otherwise your developer could use DBD::Proxy. Setting up the Proxy server on the machine with the Oracle Server.
installed.>
Thanks>
Libi>
***************************************************************************> The information contained in this communication is confidential, is> intended only for the use of the recipient named above, and may be legally> privileged.>
If the reader of this message is not the intended recipient, you are> hereby notified that any dissemination, distribution or copying of this> communication is strictly prohibited.>
If you have received this communication in error, please resend this> communication to the sender and delete the original message or any copy> of it from your computer system.>
However, you at least need an Oracle client installed on the same box. This is the Oracle_home that DBD:Oracle wants.
Cheers
John Scoles
*************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
