Re: perl query, please clear my doubt.

2003-11-27 Thread Michael A Chase
On Wed, 26 Nov 2003 20:46:38 -0800 (PST) chirag idnani <[EMAIL PROTECTED]> wrote: > Hello sir/madam, > > I am trying out a few sample perl programs to connect to a database > ( i.e msaccess using perl), i have been able to install dbi.pm on my > machine but still when i run the script i get the

Re: Oracle::OCI

2003-11-27 Thread Michael A Chase
On Wed, 26 Nov 2003 16:27:09 +0100 Rene Enskat <[EMAIL PROTECTED]> wrote: > How can i get the Module: Oracle::OCI ? http://search.cpan.org/dist/Oracle-OCI/ CPAN is your friend. -- Mac :}) ** I usually forward private questions to the appropriate mail list. ** Ask Smarter: http://www.catb.org/~

Re: dbd-oracle-1.14

2003-11-27 Thread Jim Cromie
Johannes Hermdorf wrote: My problem: Sytem: SunOS rhea 5.8 Generic_108528-23 sun4u sparc SUNW,Ultra-4 make . . (OK:and now) rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/optr/oracle9i/lib:/optr/oracle9i/rdbms/lib" gcc -G -z ignore -z lazyload -z combrelo c -L/usr/local/lib Ora

dbd-oracle-1.14

2003-11-27 Thread Johannes Hermdorf
My problem: Sytem: SunOS rhea 5.8 Generic_108528-23 sun4u sparc SUNW,Ultra-4 make . . (OK:and now) rm -f blib/arch/auto/DBD/Oracle/Oracle.so LD_RUN_PATH="/optr/oracle9i/lib:/optr/oracle9i/rdbms/lib" gcc -G -z ignore -z lazyload -z combrelo c -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci

perl query, please clear my doubt.

2003-11-27 Thread chirag idnani
Hello sir/madam, I am trying out a few sample perl programs to connect to a database ( i.e msaccess using perl), i have been able to install dbi.pm on my machine but still when i run the script i get the following error: This is the error: Can't locate object method "connect" via pack

DBD::DB2 Bug - negative REAL causes Numeric value out of range

2003-11-27 Thread Bing Wu
Greetings, Settings: DBD::DB2 v0.76 DBI v1.38 Perl v5.8.0 IBM DB2 ESE v8.1 sp 4 RedHat Linux 9 Problem: I am doing DB2 access via perl DBI but have trouble with fetching negative REAL value: i.e. SELECT X FROM TABLE FETCH FIRST ROWS ONLY; In this case, X is "-1" and the query should return "

Oracle::OCI

2003-11-27 Thread Rene Enskat
hello, How can i get the Module: Oracle::OCI ? Regards René

Re: Resulting Makefile won't 'make' during install of DBD-ODBC

2003-11-27 Thread Peter J. Holzer
On 2003-11-25 12:05:34 -0500, [EMAIL PROTECTED] wrote: > Summary: > GNU make error message -> > Makefile:303: *** missing separator. Stop. This error message usually means that a command begins with spaces instead of tabs. config :: $(changes_pm) @$(NOOP) Here they are. Replace them wi

Re: DBD::Pg for PostreSQL 7.4?

2003-11-27 Thread GB Clark
On Thu, 27 Nov 2003 15:24:54 -0500 Randall Perry <[EMAIL PROTECTED]> wrote: > Just installed PgSQL 7.4 and tried to configure DBD::Pg. Get the error: > Configuring Pg > Remember to actually read the README file! > Enter a valid PostgreSQL major version number 7.4 > Invalid value: '

Re: DBD::Pg for PostreSQL 7.4?

2003-11-27 Thread Randall Perry
I found only this: grep -r '7.4' . Binary file ./blib/arch/auto/DBD/Pg/Pg.bundle matches ./blib/lib/DBD/Pg.pm: my $indexjoin = DBD::Pg::_pg_check_version(7.4, $version) ? ./Pg.c:#line 714 "Pg.c" ./Pg.c:XSANY.any_i32 = 704 ; ./Pg.pm:my $indexjoin = DBD::Pg::_pg_che

Re: DBD::Pg for PostreSQL 7.4?

2003-11-27 Thread Jim Cromie
Randall Perry wrote: Just installed PgSQL 7.4 and tried to configure DBD::Pg. Get the error: Configuring Pg Remember to actually read the README file! Enter a valid PostgreSQL major version number 7.4 Invalid value: '7.4' Doing this on Mac OS 10.3.1, perl 5.8.2. check the DBD::Pg s

DBD::Pg for PostreSQL 7.4?

2003-11-27 Thread Randall Perry
Just installed PgSQL 7.4 and tried to configure DBD::Pg. Get the error: Configuring Pg Remember to actually read the README file! Enter a valid PostgreSQL major version number 7.4 Invalid value: '7.4' Doing this on Mac OS 10.3.1, perl 5.8.2. -- Randall Perry sysTame Xserve Web

Re: DBD::Oracle / ORACLE_HOME="/app/local/oracle/product/9.2.0" / Solaris-2.8 / ...

2003-11-27 Thread Jim Cromie
Andy Crichton wrote: This is caused by trying to link 32bit perl with 64bit oracle libraries (which live in $ORACLE_HOME/lib). What happens if you specify $ORACLE_HOME/lib32 in your LD_LIBRARY_PATH (before any other oracle paths which may be in there). Q/ Does DBD::Oracle use LD_LIBRARY_PATH

Re: Stored procs that returns resultsets to perl

2003-11-27 Thread Martin Busik
Hi, > Is there anybody out there that can > give an example of calling a stored > proc from within perl and then fetch > the result set returned by the proc? Do you mean "result value" (scalar value in terms of perl) or "result set" (more than one row)? If you mean "result value" then you can use

Re: DBD::Oracle / ORACLE_HOME="/app/local/oracle/product/9.2.0" / Solaris-2.8 / ...

2003-11-27 Thread Tim Bunce
On Thu, Nov 27, 2003 at 01:24:50PM +0100, Jochen Hayek wrote: > > LD_RUN_PATH="/app/local/oracle/product/9.2.0/lib:/app/local/oracle/product/9.2.0/rdbms/lib" > gcc -G -L/usr/local/lib Oracle.o dbdimp.o oci7.o oci8.o

Re: Trapping errors

2003-11-27 Thread Tim Bunce
On Wed, Nov 26, 2003 at 02:21:10PM -0600, Mike Blezien wrote: > Thx's Hardy,... I think I got the main idea here. Appreciate > your feedback and help :) Don't forget to look at the HandleError attribute. Tim.

Re: DBD::Oracle / ORACLE_HOME="/app/local/oracle/product/9.2.0" / Solaris-2.8 / ...

2003-11-27 Thread Michael A Chase
On Thu, 27 Nov 2003 12:46:36 - Andy Crichton <[EMAIL PROTECTED]> wrote: > This is caused by trying to link 32bit perl with 64bit oracle > libraries (which live in $ORACLE_HOME/lib). What happens if you > specify $ORACLE_HOME/lib32 in your LD_LIBRARY_PATH (before any other > oracle paths which

RE: DBD::Oracle / ORACLE_HOME="/app/local/oracle/product/9.2.0" / Solaris-2.8 / ...

2003-11-27 Thread Andy Crichton
This is caused by trying to link 32bit perl with 64bit oracle libraries (which live in $ORACLE_HOME/lib). What happens if you specify $ORACLE_HOME/lib32 in your LD_LIBRARY_PATH (before any other oracle paths which may be in there). Q/ Does DBD::Oracle use LD_LIBRARY_PATH or assume $ORACLE_HOM

Re: DBD::Oracle / ORACLE_HOME="/app/local/oracle/product/9.2.0" / Solaris-2.8 / ...

2003-11-27 Thread Jochen Hayek
> "BN" == <[EMAIL PROTECTED]> writes: BN> You can ignore that problem ( 92 numeric ) Aha. BN> Just make your perl install Well, that's just like what I have done before, as I first simply tried this (and I wrote that already in my first posting): perl -MCPAN -e 'install DBD

RE: :Oracle / ORACLE_HOME="/app/local/oracle/product/9.2.0" / Solaris-2.8 / ...

2003-11-27 Thread Bjorn.Naessens
You can ignore that problem ( 92 numeric ) Just make your perl install now then make test and make install. Kind regards Bjorn -Original Message- From: Jochen Hayek [mailto:[EMAIL PROTECTED] Sent: woensdag 26 november 2003 21:16 To: [EMAIL PROTECTED] Subject: DBD::Oracle / ORACLE_HOME=

Re: Trapping errors

2003-11-27 Thread Jim Cromie
Mike Blezien wrote: Hardy, thx's I think this maybe exactly what we were looking for, but currently do not utilize transactions in our coding. Is there another preferred way to do about the same thing without using transactions ?? thx's FWIW, you should be using transactions, esp for a Billi