RE: Help with concatenating record segments pulled from a DBIQuery
Very easily, you can either use || within your query and select from
multiple tables, if that's not possible due to complexity, then you just
select as many segments as you can (means run many queries) and then
concatinate them into a perl string. This is also not really related to
DBI, but rather to general programming and a little SQL.
Hope this helps you, if I understood the question right.
Ilya
> -Original Message-
> From: Jeff Suszczynski [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 17, 2001 12:17 PM
> To: [EMAIL PROTECTED]
> Subject: Help with concatenating record segments pulled from a DBIQuery
>
>
> Hello:
>
> Relevant background info: I program in an academic library,
> using Perl/DBI to connect to our Oracle8 database and query
> information about our books, etc.. Each book has a record,
> called a MARC record, which contains various information about
> Title, Size, Call Number, etc. This MARC record is contained in
> one or more record segments in the database. What I need to do
> for my latest project is string these record segments together to
> form the whole MARC record.
>
> So for every book that has ID=X, I need to concatenate the record
> segments into a unified whole, so that I can use the Perl module
> MARC.pm which parses through the various parts of a MARC record
> to give very granular results... The catch : MARC.pm can only
> recognize whole MARC records, not a record segment that may be
> lopped off in the middle of a field somewhere, which is why I
> need to concatenate and create only one "supersegment" for each ID number.
>
> Any ideas on how to do this within the return loop of a DBI query?
>
> A rough example of oversimplified code is below:
>
> use DBI;
> ### Grab the ID and Record Segments ###
> select
> id
> segment
> from
> table1
> where
> id > 52
> id < 99
>
> while (@row = $sth->fetchrow_array)
> {
>
> $id = $row[0];
> $seg = $row[1];
>
> then, I need something like (sorry for the mix of Perl and English) -
>
> if ($id = another $id during the loop)
> {
> pull together the $seg from each $id and call the new
> "supersegment" $full_record;
> }
> ### Basically, I am trying to make it so that if two or more
> record segments exist for a single ID, collapse those record
> segments by joining them together ###
>
> use Marc.pm;
> ### Now parse through the MARC record with my newly created
> "Supersegments" ###
> etc.
> etc.
>
> Thanks in advance for your help on this hard-to-describe problem...
>
> Jeff
>
>
>
>
>
> Jeff Suszczynski
> Systems Department, Rush Rhees Library
> University of Rochester
> 716.275.1060
>
>
Help with concatenating record segments pulled from a DBIQuery
Hello:
Relevant background info: I program in an academic library, using Perl/DBI to connect
to our Oracle8 database and query information about our books, etc.. Each book has a
record, called a MARC record, which contains various information about Title, Size,
Call Number, etc. This MARC record is contained in one or more record segments in the
database. What I need to do for my latest project is string these record segments
together to form the whole MARC record.
So for every book that has ID=X, I need to concatenate the record segments into a
unified whole, so that I can use the Perl module MARC.pm which parses through the
various parts of a MARC record to give very granular results... The catch : MARC.pm
can only recognize whole MARC records, not a record segment that may be lopped off in
the middle of a field somewhere, which is why I need to concatenate and create only
one "supersegment" for each ID number.
Any ideas on how to do this within the return loop of a DBI query?
A rough example of oversimplified code is below:
use DBI;
### Grab the ID and Record Segments ###
select
id
segment
from
table1
where
id > 52
id < 99
while (@row = $sth->fetchrow_array)
{
$id = $row[0];
$seg = $row[1];
then, I need something like (sorry for the mix of Perl and English) -
if ($id = another $id during the loop)
{
pull together the $seg from each $id and call the new "supersegment" $full_record;
}
### Basically, I am trying to make it so that if two or more record segments exist for
a single ID, collapse those record segments by joining them together ###
use Marc.pm;
### Now parse through the MARC record with my newly created "Supersegments" ###
etc.
etc.
Thanks in advance for your help on this hard-to-describe problem...
Jeff
Jeff Suszczynski
Systems Department, Rush Rhees Library
University of Rochester
716.275.1060
RE: Java error with Perl DBI
I have the following:
#&LogR'WriteHTMLPage("5a Entering connect, about to connect");
#exit;
$dbh = DBI->connect("dbi:Oracle:infotest",globalcomm, global_comm);
&LogR'WriteHTMLPage("5b Entering connect, about to connect");
exit;
If I leave the first log statement and exit commented in, it produces the
html page ok, but when I comment it out ( as shown above) the 2nd
WriteHTMLPageand exit never executes (I dont believe it gets that far), and
the Java error mentioned below ends up in the Netscape server log.
Dave Halliwill
Infobus Technology Solutions
Intranet Strategy and Access
IS Applications Solutions
Nortel Networks
615-432-4382 (ESN 222)
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 17, 2001 2:46 PM
> To: Halliwill, Dave [NASH:8M90:EXCH]
> Subject: Re: Java error with Perl DBI
>
>
>
>
> How about posting your connect statement to the list? Does
> the same page run ok
> if you comment out the DBI-related code?
>
>
>
>
> "Dave Halliwill"
> <[EMAIL PROTECTED]> on
> 08/17/2001 03:37:11 PM
>
> To: "'[EMAIL PROTECTED]'"
> <[EMAIL PROTECTED]>
> cc:(bcc: Wesley Sheldahl/Lex/Lexmark)
> Subject: Java error with Perl DBI
>
>
>
>
> I'm trying to use DBI, along with DBD::Oracle to port an
> application, and
> alter it from using Informix (DBD::Informix, I believe).
>
> When executing the DBI->connect statement, my Netscape
> Webserver is giving
> the following truncated message:
>
> [17/Aug/2001:11:47:42] failure (11594): for host
> 47.185.72.182 trying to
> POST /cgi-bin/step_1.cgi, cgieng_scan_headers reports: the
> CGI program
> /disc1/webs/2001/cgi-bin/step_1.cgi did not produce a valid
> header (name
> without value: got line "you must install a solaris patch
> to run this
> version of the java runtime.")
>
> I'm thinking this may be because DBD::JDBC was also
> installed on this
> machine, and possibly DBI is trying to use DBD::JDBS instead of
> DBD::Oracle I'm wondering
>
> 1.) How I can tell what all is installed properly (I didnt
> set perl up on
> this box myself)
> 2.) How I can tell what driver DBI is set to use.
> 3.) How to uninstall JDBC, or what solaris patch I need to
> get to alleviate
> the error
>
> Below is a list of some of the file showing whats on the machine.
> Any help is greatly apprieciated
>
> Dave Halliwill
> Infobus Technology Solutions
> Intranet Strategy and Access
> IS Applications Solutions
> Nortel Networks
> 615-432-4382 (ESN 222)
> [EMAIL PROTECTED]
>
>
> # find . -name "*DBD*" -print
> ./usr/dt/share/include/uil/UilDBDef.h
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI/DBD.pm
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBD
> ./usr/local/lib/perl5/site_perl/5.6.0/DBD
> ./usr/local/man/man3/DBD::Proxy.3
> ./usr/local/man/man3/DBD::ADO.3
> ./usr/local/man/man3/DBI::DBD.3
> ./usr/local/man/man3/DBD::Multiplex.3
> ./usr/local/man/man3/DBD::Oracle.3
> ./usr/local/man/man3/DBD::Oraperl.3
> ./usr/local/man/man3/DBD::JDBC.3
> ./export/home/jlocum/DBD-Oracle-1.05
> ./export/home/jlocum/DBD-Oracle-1.05/blib/lib/DBD
> ./export/home/jlocum/DBD-Oracle-1.05/blib/lib/auto/DBD
> ./export/home/jlocum/DBD-Oracle-1.05/blib/arch/auto/DBD
> ./export/home/jlocum/DBD-Oracle-1.05/blib/man3/DBD::Oracle.3
> ./export/home/jlocum/DBD-Oracle-1.05/blib/man3/DBD::Oraperl.3
> ./export/home/jlocum/tars/DBD-Oracle-1.05.tar
> ./export/home/jlocum/tars/DBD-JDBC-0.63.tar
> ./export/home/jlocum/tars/SUNWj2dem/reloc/demo/JAVA1.2/demo/
> jfc/DBDemos
> ./export/home/jlocum/DBI-1.14/lib/DBD
> ./export/home/jlocum/DBI-1.14/lib/DBI/DBD.pm
> ./export/home/jlocum/DBI-1.14/blib/lib/DBD
> ./export/home/jlocum/DBI-1.14/blib/lib/DBI/DBD.pm
> ./export/home/jlocum/DBI-1.14/blib/man3/DBD::Proxy.3
> ./export/home/jlocum/DBI-1.14/blib/man3/DBD::ADO.3
> ./export/home/jlocum/DBI-1.14/blib/man3/DBI::DBD.3
> ./export/home/jlocum/DBI-1.14/blib/man3/DBD::Multiplex.3
> ./export/home/jlocum/DBD-JDBC-0.63
> ./export/home/jlocum/DBD-JDBC-0.63/blib/lib/DBD
> ./export/home/jlocum/DBD-JDBC-0.63/blib/lib/auto/DBD
> ./export/home/jlocum/DBD-JDBC-0.63/blib/arch/auto/DBD
> ./export/home/jlocum/DBD-JDBC-0.63/blib/man3/DBD::JDBC.3
>
> # find . -name "*DBI*" -print
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBIXS.h
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBI.so
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBI.bs
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI.pm
> ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Win32/DBIODBC.pm
> ./usr/local/lib/perl5/site_p
Java error with Perl DBI
I'm trying to use DBI, along with DBD::Oracle to port an application, and alter it from using Informix (DBD::Informix, I believe). When executing the DBI->connect statement, my Netscape Webserver is giving the following truncated message: [17/Aug/2001:11:47:42] failure (11594): for host 47.185.72.182 trying to POST /cgi-bin/step_1.cgi, cgieng_scan_headers reports: the CGI program /disc1/webs/2001/cgi-bin/step_1.cgi did not produce a valid header (name without value: got line "you must install a solaris patch to run this version of the java runtime.") I'm thinking this may be because DBD::JDBC was also installed on this machine, and possibly DBI is trying to use DBD::JDBS instead of DBD::Oracle I'm wondering 1.) How I can tell what all is installed properly (I didnt set perl up on this box myself) 2.) How I can tell what driver DBI is set to use. 3.) How to uninstall JDBC, or what solaris patch I need to get to alleviate the error Below is a list of some of the file showing whats on the machine. Any help is greatly apprieciated Dave Halliwill Infobus Technology Solutions Intranet Strategy and Access IS Applications Solutions Nortel Networks 615-432-4382 (ESN 222) [EMAIL PROTECTED] # find . -name "*DBD*" -print ./usr/dt/share/include/uil/UilDBDef.h ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBD ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI/DBD.pm ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBD ./usr/local/lib/perl5/site_perl/5.6.0/DBD ./usr/local/man/man3/DBD::Proxy.3 ./usr/local/man/man3/DBD::ADO.3 ./usr/local/man/man3/DBI::DBD.3 ./usr/local/man/man3/DBD::Multiplex.3 ./usr/local/man/man3/DBD::Oracle.3 ./usr/local/man/man3/DBD::Oraperl.3 ./usr/local/man/man3/DBD::JDBC.3 ./export/home/jlocum/DBD-Oracle-1.05 ./export/home/jlocum/DBD-Oracle-1.05/blib/lib/DBD ./export/home/jlocum/DBD-Oracle-1.05/blib/lib/auto/DBD ./export/home/jlocum/DBD-Oracle-1.05/blib/arch/auto/DBD ./export/home/jlocum/DBD-Oracle-1.05/blib/man3/DBD::Oracle.3 ./export/home/jlocum/DBD-Oracle-1.05/blib/man3/DBD::Oraperl.3 ./export/home/jlocum/tars/DBD-Oracle-1.05.tar ./export/home/jlocum/tars/DBD-JDBC-0.63.tar ./export/home/jlocum/tars/SUNWj2dem/reloc/demo/JAVA1.2/demo/jfc/DBDemos ./export/home/jlocum/DBI-1.14/lib/DBD ./export/home/jlocum/DBI-1.14/lib/DBI/DBD.pm ./export/home/jlocum/DBI-1.14/blib/lib/DBD ./export/home/jlocum/DBI-1.14/blib/lib/DBI/DBD.pm ./export/home/jlocum/DBI-1.14/blib/man3/DBD::Proxy.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBD::ADO.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBI::DBD.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBD::Multiplex.3 ./export/home/jlocum/DBD-JDBC-0.63 ./export/home/jlocum/DBD-JDBC-0.63/blib/lib/DBD ./export/home/jlocum/DBD-JDBC-0.63/blib/lib/auto/DBD ./export/home/jlocum/DBD-JDBC-0.63/blib/arch/auto/DBD ./export/home/jlocum/DBD-JDBC-0.63/blib/man3/DBD::JDBC.3 # find . -name "*DBI*" -print ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBIXS.h ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBI.so ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/auto/DBI/DBI.bs ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI.pm ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Win32/DBIODBC.pm ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/Bundle/DBI.pm ./usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris/DBI ./usr/local/man/man3/DBI::ProxyServer.3 ./usr/local/man/man3/DBI::Format.3 ./usr/local/man/man3/DBI::Shell.3 ./usr/local/man/man3/DBI.3 ./usr/local/man/man3/DBI::FAQ.3 ./usr/local/man/man3/Bundle::DBI.3 ./usr/local/man/man3/Win32::DBIODBC.3 ./usr/local/man/man3/DBI::W32ODBC.3 ./usr/local/man/man3/DBI::DBD.3 ./export/home/jlocum/tars/DBI-1.14.tar ./export/home/jlocum/DBI-1.14 ./export/home/jlocum/DBI-1.14/lib/DBI ./export/home/jlocum/DBI-1.14/lib/Bundle/DBI.pm ./export/home/jlocum/DBI-1.14/lib/Win32/DBIODBC.pm ./export/home/jlocum/DBI-1.14/DBI.xs ./export/home/jlocum/DBI-1.14/DBIXS.h ./export/home/jlocum/DBI-1.14/DBI.pm ./export/home/jlocum/DBI-1.14/blib/lib/auto/DBI ./export/home/jlocum/DBI-1.14/blib/lib/DBI ./export/home/jlocum/DBI-1.14/blib/lib/DBI.pm ./export/home/jlocum/DBI-1.14/blib/lib/Bundle/DBI.pm ./export/home/jlocum/DBI-1.14/blib/lib/Win32/DBIODBC.pm ./export/home/jlocum/DBI-1.14/blib/arch/auto/DBI ./export/home/jlocum/DBI-1.14/blib/arch/auto/DBI/DBIXS.h ./export/home/jlocum/DBI-1.14/blib/arch/auto/DBI/DBI.so ./export/home/jlocum/DBI-1.14/blib/arch/auto/DBI/DBI.bs ./export/home/jlocum/DBI-1.14/blib/man3/DBI::ProxyServer.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBI::Format.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBI::Shell.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBI.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBI::FAQ.3 ./export/home/jlocum/DBI-1.14/blib/man3/Bundle::DBI.3 ./export/home/jlocum/DBI-1.14/blib/man3/Win32::DBIODBC.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBI::W32ODBC.3 ./export/home/jlocum/DBI-1.14/blib/man3/DBI::DBD.3 ./export/home/jlocum/
Oracle 9i/dbd
I have installed Oracle 9i on a RH 7.1 server. I have done a database install to make sure I got all of the required files. I can connect to a remote database using sqlplus. I have installed DBI 1.19, make test and make install work. I am trying to install DBD 1.07 for Oracle. On "make test" I am receiving the following output. I have searched everywhere and tried a few solutions but none have worked (README's included). Any ideas? Thanks PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.6.0/i3 86-linux -I/usr/lib/perl5/5.6.0 -e 'use Test::Harness qw(&runtests $verbose); $v erbose=0; runtests @ARGV;' t/*.t t/base..ok 3/5FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/general...install_driver(Oracle) failed: Can't load 'blib/arch/auto/DB D/Oracle/Oracle.so' for module DBD::Oracle: blib/arch/auto/DBD/Oracle/Oracle.so: undefined symbol: OCIServerAttach at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader .pm line 200. 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 at t/general.t line 20 t/general...dubious Test returned status 255 (wstat 65280, 0xff00) t/long..Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: blib/arch/auto/DBD/Oracle/Oracle.so: undefined symbol: OCIServerAtt ach at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 200. at t/long.t line 4 Compilation failed in require at t/long.t line 4. BEGIN failed--compilation aborted at t/long.t line 4. t/long..dubious Test returned status 255 (wstat 65280, 0xff00) t/plsql.Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: blib/arch/auto/DBD/Oracle/Oracle.so: undefined symbol: OCIServerAtt ach at /usr/lib/perl5/5.6.0/i386-linux/DynaLoader.pm line 200. at t/plsql.t line 17 Compilation failed in require at t/plsql.t line 17. BEGIN failed--compilation aborted at t/plsql.t line 17. t/plsql.dubious Test returned status 255 (wstat 65280, 0xff00) t/reauthskipped test on this platform Failed Test Status Wstat Total Fail Failed List of failed --- t/base.t 52 40.00% 4-5 t/general.t 255 65280?? ?? % ?? t/long.t255 65280?? ?? % ?? t/plsql.t 255 65280?? ?? % ?? 1 test skipped. Failed 4/5 test scripts, 20.00% okay. 2/5 subtests failed, 60.00% okay. make: *** [test_dynamic] Error 29 >> Jeffrey P. Besecker Project Manager PG Energy division of Southern Union Co.
Thanks! I'll try everyones solutions after my vacation Leaving now for 1 week--How to install DBI on AIX; need DBDSybase and DBDOracle to wo rk
-Original Message- From: Curt Russell Crandall [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:14 PM To: Rice, Wayne R (Sybase) Cc: [EMAIL PROTECTED] Subject: RE: How to install DBI on AIX; need DBDSybase and DBDOracle to wo rk Maybe I've missed something... but I'd recommend not using a tarball directly and just use the CPAN module to install it: perl -MCPAN -e "install 'DBI'" perl -MCPAN -e "install 'DBD::Sybase'" perl -MCPAN -e "install 'DBD::Oracle'" assuming you have a standard setup on your box, you can probably just select the defaults for everything and let CPAN.pm do all the dirty work. This is pretty much the same way PPM works with ActiveState. HTH, Curt
RE: How to install DBI on AIX; need DBDSybase and DBDOracle to work
Maybe I've missed something... but I'd recommend not using a tarball directly and just use the CPAN module to install it: perl -MCPAN -e "install 'DBI'" perl -MCPAN -e "install 'DBD::Sybase'" perl -MCPAN -e "install 'DBD::Oracle'" assuming you have a standard setup on your box, you can probably just select the defaults for everything and let CPAN.pm do all the dirty work. This is pretty much the same way PPM works with ActiveState. HTH, Curt
RE: How to install DBI on AIX; need DBDSybase and DBDOracle to wo rk
I've been working with AIX, DBI and DBD::Oracle since 1998, I installed them with differents versions of AIX, Oracle, DBI, DBD::Oracle and C compilers and never had big problems. I recommend that you transfer the 'tarball' file to the AIX box and then unpack it. Some windows ftp clients don't care about uppercase and lowercase. Best regards, Marcelo "Rice, Wayne R (Sybase)"To: "'Michael Peppler'" <[EMAIL PROTECTED]>, "Rice, Wayne R .navy.mil> cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, 17/08/2001"'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, 14:49 "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Please respond Subject: RE: How to install DBI on AIX; need DBDSybase and DBDOracle to "Rice, to wo rk Wayne R (Sybase)" Michael, To clear things up a little, I have my Sybase laptop with Windows 2000 which has Active State installed. I then used the PPM to install my DBI and Sybase and Oracle DBDs. This is one environment where things work ok. The other environement which is going to be the official production environment is UNIX AIX. I am having no success here. Now, you say to type perl Makefile.PL (noting caps). However, after expanding the file after the download, the file is all lowercase. The way I expand it is to use my NT 4.0 workstation using winzip. Then I ftp the files over to a unix folder where it is lowercase. Then I type 'perl makefile.pl'. Can I use winzip and ftp the files as I have? Where should I put the expanded files on my unix server? What authorization do I need to do the work (i.e. root level)? Concerning the PERL5LIB variable, it is not set... see below... ricew@spnode01> echo $PERL5LIB /u/ricew ricew@spnode01> Thanks, Wayne -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:14 PM To: Rice, Wayne R (Sybase) Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Re: How to install DBI on AIX; need DBDSybase and DBDOracle to work Rice, Wayne R (Sybase) writes: > Anyone, > > I need to gain access to Oracle and Sybase on an AIX Unix system. I tried > perl makefile.pl; make; etc. to no avail. Please advise what steps do I > need to follow to get things to work on this platform. > > (Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase > and DBDOracle. I used PPM to install the 1 DBI and 2 DBD packages) I'm a little confused here - are you using ActiveState on AIX, or are you saying that you successfully installed DBI/DBD::xxx on Win32 with ActiveState? Anyway - you first should run perl Makefile.PL (note caps) for DBI. If that fails there is no point in going any further - you first need to figure out why it fails. > ricew@spnode01> perl makefile.pl > Can't locate loadable object for module DBI in @INC (@INC contains: lib lib/dbi /u/ricew/Software/dbi-1.19 /u/ricew/Software/dbi-1.19/DBI /u/ricew/Software/dbi-1.19/DBDOracle /u/ricew/Software/dbi-1.19/DBDSybase /usr/opt/perl5/lib/5.00503/aix /usr/opt/perl5/lib/5.00503 /usr/opt/perl5/lib/site_perl/5.005/aix /usr/opt/perl5/lib/site_perl/5.005 .) at DBI.pm line 185 > BEGIN failed--compilation aborted at DBI.pm line 185. > BEGIN failed--compilation aborted at lib/DBI/DBD.pm line 1777. > BEGIN failed--compilation aborted at makefile.pl line 224. Do you have the PERL5LIB variable set to some weird value? Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
RE: How to install DBI on AIX; need DBDSybase and DBDOracle to work
Michael, To clear things up a little, I have my Sybase laptop with Windows 2000 which has Active State installed. I then used the PPM to install my DBI and Sybase and Oracle DBDs. This is one environment where things work ok. The other environement which is going to be the official production environment is UNIX AIX. I am having no success here. Now, you say to type perl Makefile.PL (noting caps). However, after expanding the file after the download, the file is all lowercase. The way I expand it is to use my NT 4.0 workstation using winzip. Then I ftp the files over to a unix folder where it is lowercase. Then I type 'perl makefile.pl'. Can I use winzip and ftp the files as I have? Where should I put the expanded files on my unix server? What authorization do I need to do the work (i.e. root level)? Concerning the PERL5LIB variable, it is not set... see below... ricew@spnode01> echo $PERL5LIB /u/ricew ricew@spnode01> Thanks, Wayne -Original Message- From: Michael Peppler [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:14 PM To: Rice, Wayne R (Sybase) Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Re: How to install DBI on AIX; need DBDSybase and DBDOracle to work Rice, Wayne R (Sybase) writes: > Anyone, > > I need to gain access to Oracle and Sybase on an AIX Unix system. I tried > perl makefile.pl; make; etc. to no avail. Please advise what steps do I > need to follow to get things to work on this platform. > > (Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase > and DBDOracle. I used PPM to install the 1 DBI and 2 DBD packages) I'm a little confused here - are you using ActiveState on AIX, or are you saying that you successfully installed DBI/DBD::xxx on Win32 with ActiveState? Anyway - you first should run perl Makefile.PL (note caps) for DBI. If that fails there is no point in going any further - you first need to figure out why it fails. > ricew@spnode01> perl makefile.pl > Can't locate loadable object for module DBI in @INC (@INC contains: lib lib/dbi /u/ricew/Software/dbi-1.19 /u/ricew/Software/dbi-1.19/DBI /u/ricew/Software/dbi-1.19/DBDOracle /u/ricew/Software/dbi-1.19/DBDSybase /usr/opt/perl5/lib/5.00503/aix /usr/opt/perl5/lib/5.00503 /usr/opt/perl5/lib/site_perl/5.005/aix /usr/opt/perl5/lib/site_perl/5.005 .) at DBI.pm line 185 > BEGIN failed--compilation aborted at DBI.pm line 185. > BEGIN failed--compilation aborted at lib/DBI/DBD.pm line 1777. > BEGIN failed--compilation aborted at makefile.pl line 224. Do you have the PERL5LIB variable set to some weird value? Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
Re: How to install DBI on AIX; need DBDSybase and DBDOracle to work
Rice, Wayne R (Sybase) writes: > Anyone, > > I need to gain access to Oracle and Sybase on an AIX Unix system. I tried > perl makefile.pl; make; etc. to no avail. Please advise what steps do I > need to follow to get things to work on this platform. > > (Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase > and DBDOracle. I used PPM to install the 1 DBI and 2 DBD packages) I'm a little confused here - are you using ActiveState on AIX, or are you saying that you successfully installed DBI/DBD::xxx on Win32 with ActiveState? Anyway - you first should run perl Makefile.PL (note caps) for DBI. If that fails there is no point in going any further - you first need to figure out why it fails. > ricew@spnode01> perl makefile.pl > Can't locate loadable object for module DBI in @INC (@INC contains: lib lib/dbi >/u/ricew/Software/dbi-1.19 /u/ricew/Software/dbi-1.19/DBI >/u/ricew/Software/dbi-1.19/DBDOracle /u/ricew/Software/dbi-1.19/DBDSybase >/usr/opt/perl5/lib/5.00503/aix /usr/opt/perl5/lib/5.00503 >/usr/opt/perl5/lib/site_perl/5.005/aix /usr/opt/perl5/lib/site_perl/5.005 .) at >DBI.pm line 185 > BEGIN failed--compilation aborted at DBI.pm line 185. > BEGIN failed--compilation aborted at lib/DBI/DBD.pm line 1777. > BEGIN failed--compilation aborted at makefile.pl line 224. Do you have the PERL5LIB variable set to some weird value? Michael -- Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler [EMAIL PROTECTED] - [EMAIL PROTECTED] International Sybase User Group - http://www.isug.com
AM I GETTING TO THE USER GROUP??? -->How to install DBI on AIX; need DBDSybase and DBDOracle to work
-Original Message- From: Rice, Wayne R (Sybase) Sent: Thursday, August 16, 2001 1:56 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: How to install DBI on AIX; need DBDSybase and DBDOracle to work Anyone, (Eric of Sybase, can you help me/Wes with this?) This is my third attempt at getting a reply from the [EMAIL PROTECTED] group. PLEASE, ANYONE SAY SOMETHING SO I KNOW I'M GETTING THROUGH. I need to gain access to Oracle and Sybase on an AIX Unix system via trying to install DBI (non-ActiveStat DBI). I tried perl makefile.pl; make; etc. as the README suggested to no avail. Please advise what steps do I need to follow to get things to work on this platform. Wes Stephens, also in this email, will receive any mail in reply as I may be out some of next week so please reply to ALL. (Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase and DBDOracle. I used PPM to install the 1 DBI and 2 DBD packages on NT for this and it all went smooth...) But getting DBI to work (makefile.pl, make, etc) has not been possible. Could someone reply from the user group so I know I'm getting through please... THANKS IN ADVANCE! Any help will be greatly appreciated!!! Here are the files requested per Mr. Bunce re the runtimes and perl -V environment ... Thank You, Wayne Rice Sybase, Inc.
Re: "SET TRANSACTION READ ONLY" / "SET TRANSACTION USE ROLLBACK SEGMENT"
On Fri, Aug 17, 2001 at 12:26:29PM -0400, Hugo A. Gonzalez F. wrote:
> O.K.
>
> Excuse my ENGLISH, but i try to tell to you my problem, if any body can
> undestand in spanish and can translate to english "best".
>
> I use this sentences: " Set Transaction read only " / "Set transaction
> use rollback segment " , in perl's progrmas, but still use any
> rollback, and my idea is that use none or one in exclusive, from PERL.
Okay... Hugo is doing Set Transaction statements that should change how
his queries use rollback segments, but the behavior of his queries isn't
actually changing.
Have you turned off AutoCommit? With AutoCommit on, I think that the Set
Transaction will last only for the duration of the Set Transaction
statement.
You can turn off AutoCommit when you connect:
$dbh = DBI->connect($dsn, $username, $password, { AutoCommit => 0 });
or sometime after you connect:
$dbh->{AutoCommit} = 0;
Also, after you call $dbh->commit(), I think you will need to do the Set
Transaction statement again.
> The version is ORACLE 8.1.7, and PERL 5.003.
Are you really using perl5.003, or did you mean perl5.005_03? perl5.003 is
quite old.
I hope that's helpful!
Ronald
Re: "SET TRANSACTION READ ONLY" / "SET TRANSACTION USE ROLLBACKSEGMENT"
On Fri, 17 Aug 2001, Hugo A. Gonzalez F. wrote:
..
> I use this sentences: " Set Transaction read only " / "Set transaction
> use rollback segment " , in perl's progrmas, but still use any
> rollback, and my idea is that use none or one in exclusive, from PERL.
>
> The version is ORACLE 8.1.7, and PERL 5.003.
$dbh->do("SET TRANSACTION USE ROLLBACK SEGMENT U7");
seems to work for me..
--
Orlando Andico <[EMAIL PROTECTED]>
Mosaic Communications, Inc.
-BEGIN GEEK CODE BLOCK-
Version: 3.12
GE d(-) s: a-25 C UBLSI$ P+++ L+++> E- W++ N(+)
o K? w O-- M- !V PS(++) PE- Y PGP-- t(+)@ 5(+) X++@ R(+) tv@
b++ DI++ G e++@ h--(*) r% y+
--END GEEK CODE BLOCK--
"SET TRANSACTION READ ONLY" / "SET TRANSACTION USE ROLLBACK SEGMENT"
O.K. Excuse my ENGLISH, but i try to tell to you my problem, if any body can undestand in spanish and can translate to english "best". I use this sentences: " Set Transaction read only " / "Set transaction use rollback segment " , in perl's progrmas, but still use any rollback, and my idea is that use none or one in exclusive, from PERL. The version is ORACLE 8.1.7, and PERL 5.003. One more time: excuse my english, i promise to you be better about this. Thanks, Hugo Gonzalez. --- 0 - > Buenos Dias: > > Utilizando ORACLE 8.1.7 y PERL 5.003 > >Al utilizar sentencias en PERL : " Set Transaction read only " / "Set > transaction use rollback segment " , y no lo aplica en el programa > donde lo utilizo, Y por supuesto siempre termina con "SNAP SHOT TOO OLD > " > > Hugo Gonzalez.
When DBI::err gets overwritten
Hi. I understand that DBI::err is very transient. My question is, is it going to get overwritten in between the different calls in selectcol_array? That is, I'm doing: my $arrayref = $dbh->selectcol_arrayref($statement, undef, @bind) or die($dbh->errstr()); my @arr = @$arrayref; I realized that this won't check for all possible errors, because if there's an error during selectcol's first fetch, it will just return [] (as far as I can tell, from the docs saying it returns "all the information it has so far"). I could add: die $dbh->errstr() if !@arr && $DBI::err; Or, I could do just one test by changing the code to: my $arrayref = $dbh->selectcol_arrayref($statement, undef, @bind); die($dbh->errstr()) if $DBI::err; my @arr = @$arrayref; However, both these methods require that DBI::err will still be set at the right time. So, will either these work, or is there a different way to do it? Amir Karger Curagen Corporation LEGAL NOTICE - Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.
Re: DBI-1.19 leak?
On Fri, Aug 17, 2001 at 04:32:31PM +0200, Toni Andjelkovic wrote: > Tim Bunce wrote on Fri, Aug 17 2001 (11:51:18 +0100): > > Keep removing bits till the leak stops to find out which bit leaks. > > even this leaks: > > my $dbh = DBI->connect(...); > $dbh->disconnect; > undef $dbh; > > this might stop it: > > --- DBI.xs.dist Fri Aug 17 16:00:36 2001 > +++ DBI.xs Fri Aug 17 16:27:34 2001 > @@ -948,0 +949 @@ > + sv_free(_imp2com(imp_xxh, attr.FetchHashKeyName)); Excellent. Many thanks. Tim.
Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
On Fri, Aug 17, 2001 at 03:48:39PM +0200, Oleg Mechtcheriakov wrote: > OK, I've tried that. But the result is very tricky. > > When I did it first time it was OK, at least the connection was established. > When I apply one minor change with the source file -- it doesn't work > anymore even when I went back to the initial source code. It looks > absolutely misterious but I'll try to sort it out somehow to have at least > stable result. Talk to Oracle. Till their own code works DBD::Oracle is unlikely to. > BTW, if I switch to DBI proxy -- how big would be slow-down? This big |<-->| Try it. Tim. > Reg's > Oleg > > > -Original Message- > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 17, 2001 1:26 PM > > To: Oleg Mechtcheriakov > > Cc: 'Tim Bunce'; [EMAIL PROTECTED] > > Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 > > > > > > > > You'll have to try building one of the oci demo programs in > > $ORACLE_HOME/rdbms/demo and see if that connects okay. > > > > Tim. > > > > On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: > > > Hi, > > > > > > thanks for a reaction. > > > > > > Here comes the protocol of my SQLPLUS session: > > > > > > ==> > > > root@XXX:/root > sqlplus scott/tiger@VENUS > > > SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 > > > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > > > > > Connected to: > > > Oracle8 Release 8.0.6.0.0 - Production > > > PL/SQL Release 8.0.6.0.0 - Production > > > > > > SQL> select count(*) from emp; > > > COUNT(*) > > > -- > > > 14 > > > SQL> exit > > > Disconnected from Oracle8 Release 8.0.6.0.0 - Production > > > PL/SQL Release 8.0.6.0.0 - Production > > > root@XXX:/root > > > > ==> > > > > > > Select is made just to make sure that it really works:-) > > And it is really > > > the Oracle instance on the remote host as can be seen from version > > > numbers... > > > > > > Reg's > > > Oleg > > > > > > > > > > > > > > > > -Original Message- > > > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > > > Sent: Thursday, August 16, 2001 5:40 PM > > > > To: Oleg Mechtcheriakov > > > > Cc: [EMAIL PROTECTED] > > > > Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 > > > > > > > > > > > > On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg > > Mechtcheriakov wrote: > > > > > > > > > > The point is that connection from perl script failes > > > > whereas the connection > > > > > with SQLPLUS works OK. > > > > > > > > With what command line, exactly? > > > > > > > > > P.S. Forgot to say that to get to that point we had to > > > > recompile Perl and > > > > > DBI/DBD without threads support. Without that we saw just > > > > segmentation > > > > > faults... > > > > > > > > Such is the way with threads and perl. > > > > > > > > Tim. > > > > > > > > > >
Re: DBI-1.19 leak?
Tim Bunce wrote on Fri, Aug 17 2001 (11:51:18 +0100): > Keep removing bits till the leak stops to find out which bit leaks. even this leaks: my $dbh = DBI->connect(...); $dbh->disconnect; undef $dbh; this might stop it: --- DBI.xs.dist Fri Aug 17 16:00:36 2001 +++ DBI.xs Fri Aug 17 16:27:34 2001 @@ -948,0 +949 @@ + sv_free(_imp2com(imp_xxh, attr.FetchHashKeyName)); cu, -- Toni Andjelkovic <[EMAIL PROTECTED]>
RE: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
OK, I've tried that. But the result is very tricky. When I did it first time it was OK, at least the connection was established. When I apply one minor change with the source file -- it doesn't work anymore even when I went back to the initial source code. It looks absolutely misterious but I'll try to sort it out somehow to have at least stable result. BTW, if I switch to DBI proxy -- how big would be slow-down? Reg's Oleg > -Original Message- > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 17, 2001 1:26 PM > To: Oleg Mechtcheriakov > Cc: 'Tim Bunce'; [EMAIL PROTECTED] > Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 > > > > You'll have to try building one of the oci demo programs in > $ORACLE_HOME/rdbms/demo and see if that connects okay. > > Tim. > > On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: > > Hi, > > > > thanks for a reaction. > > > > Here comes the protocol of my SQLPLUS session: > > > > ==> > > root@XXX:/root > sqlplus scott/tiger@VENUS > > SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 > > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > > > Connected to: > > Oracle8 Release 8.0.6.0.0 - Production > > PL/SQL Release 8.0.6.0.0 - Production > > > > SQL> select count(*) from emp; > > COUNT(*) > > -- > > 14 > > SQL> exit > > Disconnected from Oracle8 Release 8.0.6.0.0 - Production > > PL/SQL Release 8.0.6.0.0 - Production > > root@XXX:/root > > > ==> > > > > Select is made just to make sure that it really works:-) > And it is really > > the Oracle instance on the remote host as can be seen from version > > numbers... > > > > Reg's > > Oleg > > > > > > > > > > > -Original Message- > > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, August 16, 2001 5:40 PM > > > To: Oleg Mechtcheriakov > > > Cc: [EMAIL PROTECTED] > > > Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 > > > > > > > > > On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg > Mechtcheriakov wrote: > > > > > > > > The point is that connection from perl script failes > > > whereas the connection > > > > with SQLPLUS works OK. > > > > > > With what command line, exactly? > > > > > > > P.S. Forgot to say that to get to that point we had to > > > recompile Perl and > > > > DBI/DBD without threads support. Without that we saw just > > > segmentation > > > > faults... > > > > > > Such is the way with threads and perl. > > > > > > Tim. > > > > > >
Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
You'll have to try building one of the oci demo programs in $ORACLE_HOME/rdbms/demo and see if that connects okay. Tim. On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: > Hi, > > thanks for a reaction. > > Here comes the protocol of my SQLPLUS session: > > ==> > root@XXX:/root > sqlplus scott/tiger@VENUS > SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > Connected to: > Oracle8 Release 8.0.6.0.0 - Production > PL/SQL Release 8.0.6.0.0 - Production > > SQL> select count(*) from emp; > COUNT(*) > -- > 14 > SQL> exit > Disconnected from Oracle8 Release 8.0.6.0.0 - Production > PL/SQL Release 8.0.6.0.0 - Production > root@XXX:/root > > ==> > > Select is made just to make sure that it really works:-) And it is really > the Oracle instance on the remote host as can be seen from version > numbers... > > Reg's > Oleg > > > > > > -Original Message- > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 16, 2001 5:40 PM > > To: Oleg Mechtcheriakov > > Cc: [EMAIL PROTECTED] > > Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 > > > > > > On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: > > > > > > The point is that connection from perl script failes > > whereas the connection > > > with SQLPLUS works OK. > > > > With what command line, exactly? > > > > > P.S. Forgot to say that to get to that point we had to > > recompile Perl and > > > DBI/DBD without threads support. Without that we saw just > > segmentation > > > faults... > > > > Such is the way with threads and perl. > > > > Tim. > > >
RE: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
Nop, same picture... :-( Oleg > -Original Message- > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 17, 2001 12:50 PM > To: Oleg Mechtcheriakov > Cc: 'Tim Bunce'; [EMAIL PROTECTED] > Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 > > > Given what someone else reported recently, try editing your script > to add newline characters at the end of the username and password. > Let me know if that fixes it. > > Tim. > > On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: > > Hi, > > > > thanks for a reaction. > > > > Here comes the protocol of my SQLPLUS session: > > > > ==> > > root@XXX:/root > sqlplus scott/tiger@VENUS > > SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 > > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > > > Connected to: > > Oracle8 Release 8.0.6.0.0 - Production > > PL/SQL Release 8.0.6.0.0 - Production > > > > SQL> select count(*) from emp; > > COUNT(*) > > -- > > 14 > > SQL> exit > > Disconnected from Oracle8 Release 8.0.6.0.0 - Production > > PL/SQL Release 8.0.6.0.0 - Production > > root@XXX:/root > > > ==> > > > > Select is made just to make sure that it really works:-) > And it is really > > the Oracle instance on the remote host as can be seen from version > > numbers... > > > > Reg's > > Oleg > > > > > > > > > > > -Original Message- > > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, August 16, 2001 5:40 PM > > > To: Oleg Mechtcheriakov > > > Cc: [EMAIL PROTECTED] > > > Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 > > > > > > > > > On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg > Mechtcheriakov wrote: > > > > > > > > The point is that connection from perl script failes > > > whereas the connection > > > > with SQLPLUS works OK. > > > > > > With what command line, exactly? > > > > > > > P.S. Forgot to say that to get to that point we had to > > > recompile Perl and > > > > DBI/DBD without threads support. Without that we saw just > > > segmentation > > > > faults... > > > > > > Such is the way with threads and perl. > > > > > > Tim. > > > > > >
Re: DBI-1.19 leak?
Keep removing bits till the leak stops to find out which bit leaks.
Tim.
On Fri, Aug 17, 2001 at 01:30:51AM +0200, Toni Andjelkovic wrote:
> the following code appears to leak memory with
> DBI-1.19, but not with DBI-1.18. i tried with
> perl-5.6.1.
>
> can anyone confirm this?
>
> # ---
> use DBI;
> use Getopt::Std;
>
> getopts('n:', my $opt = {}) or die "usage: $0 [-n loops]\n";
> my $loops = $opt->{n} || 1;
> for (1 .. $loops) {
> my $dbh = DBI->connect(
> 'DBI:Pg:dbname=foobar;host=dbhost01;port=5432',
> 'dbuser',
> 'dbpassword',
> );
> my $sth = $dbh->prepare("SELECT * FROM Customer WHERE ID = 1");
> $sth->execute;
> my $hashref = $sth->fetchrow_hashref;
> $sth->finish;
> $dbh->disconnect;
> print STDERR ".";
> }
> # ---
>
> cheers,
> --
> Toni Andjelkovic
> <[EMAIL PROTECTED]>
>
Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08
Given what someone else reported recently, try editing your script to add newline characters at the end of the username and password. Let me know if that fixes it. Tim. On Fri, Aug 17, 2001 at 09:25:19AM +0200, Oleg Mechtcheriakov wrote: > Hi, > > thanks for a reaction. > > Here comes the protocol of my SQLPLUS session: > > ==> > root@XXX:/root > sqlplus scott/tiger@VENUS > SQL*Plus: Release 8.1.5.0.0 - Production on Fri Aug 17 09:13:17 2001 > (c) Copyright 1999 Oracle Corporation. All rights reserved. > > Connected to: > Oracle8 Release 8.0.6.0.0 - Production > PL/SQL Release 8.0.6.0.0 - Production > > SQL> select count(*) from emp; > COUNT(*) > -- > 14 > SQL> exit > Disconnected from Oracle8 Release 8.0.6.0.0 - Production > PL/SQL Release 8.0.6.0.0 - Production > root@XXX:/root > > ==> > > Select is made just to make sure that it really works:-) And it is really > the Oracle instance on the remote host as can be seen from version > numbers... > > Reg's > Oleg > > > > > > -Original Message- > > From: Tim Bunce [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 16, 2001 5:40 PM > > To: Oleg Mechtcheriakov > > Cc: [EMAIL PROTECTED] > > Subject: Re: Oracle 8.1.5 + Solaris 2.8/Intel + DBD::Oracle 1.08 > > > > > > On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote: > > > > > > The point is that connection from perl script failes > > whereas the connection > > > with SQLPLUS works OK. > > > > With what command line, exactly? > > > > > P.S. Forgot to say that to get to that point we had to > > recompile Perl and > > > DBI/DBD without threads support. Without that we saw just > > segmentation > > > faults... > > > > Such is the way with threads and perl. > > > > Tim. > > >
