Just to follow up: DBI.pm is in
/Library/Perl/darwin/
on my machine, and I think I did a standard install.
Is /Library/Perl/darwin/DBI.pm on your machine, along with the DBI directory, and is
it readable by the user running the script?
-Chris
-Original Message-
From: Phil Dobbin
S
Thanks Steven,
But all I can see on this talk (on slide 89?) is the new syntax of
fetchall_arrayref, which is already used in my example.
I was looking for a better way to construct a while loop with
fetchall_arrayref. The problem is that when you fetch the last lot of data,
the statement hand
Hi all,
Below is a perl Makefile.PL and make session. The make failed
saying it couldn't find ocidfn.h? Any ideas?
Output of uname -a:
SunOS trna 5.8 Generic_108528-11 sun4u sparc SUNW,Sun-Fire-880
[188] trna:/home/harsch/installs/perl_mods/DBI/Oracle9/DBD-Oracle-1.12>
perl64 Makefile.
Hi All!
New to the list, so sorry if the question was already answered.
I need a help ASAP...
How can I call a PostgreSQL stored fuction from perl, with DBI (DBD:Pg)?
I just cannot find any doc on the net about this topic... :-(
Thx,
L.
If anyone else is having problems upgrading to 1.30 for DBI made all the difference &
there wasn't a hitch this time with DBD::Oracle
Thank you Tim
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 13, 2002 2:56 PM
To: Mitchel, Jennifer (Jem)
Cc: '[E
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Aug 14, 2002 at 08:12:50PM +0100, Paul Rundle wrote:
> Attempting to insert approx 20k of ASCII into a CLOB (Oracle 9i), I am
> receiving this error:
>
> Server returned error: Failed to execute method CallMethod: DBD::Oracle::st
> execute
Attempting to insert approx 20k of ASCII into a CLOB (Oracle 9i), I am
receiving this error:
Server returned error: Failed to execute method CallMethod: DBD::Oracle::st
execute failed: ORA-01704: string literal too long (DBD ERROR:
OCIStmtExecute)
Why are large data inserts causing problems?
On 14/08/2002 at 10:03, Sarnowski, Chris, [EMAIL PROTECTED] wrote:
>A thought: Has one of the recent security upgrades changed perl?
[snip]
No. Mac OS X is still at 5.6.0 as shipped by Apple.
Have you updated anything (Perl, DBI, mysql, etc) lately [stupid question, I
know]...or disconnected
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, Aug 14, 2002 at 01:52:06PM -0400, Paul Vallee wrote:
> I'm dying to start using prepare_cached, but thus far the risk has always
> seemed too great. I never heard about this again after this discussion, and
> I'm not aware of any resolution or
Hello Tim,
I'm dying to start using prepare_cached, but thus far the risk has always
seemed too great. I never heard about this again after this discussion, and
I'm not aware of any resolution or any version of DBI in which
prepare_cached is safe. I'm sorry to bother you directly but I have
exhau
Dear DBI Group,
I've tried to install DBI on HP-UX 11.11
perl Makefile.PL is successful but the make fails with a parsing error.
Can anybody help please?
Regards,
Laszlo Jakab
--- 5 : perl Makefile.PL
*** You are using a perl configured with threading enabled.
*** You should be aware that
I wouldn't post this to dbi-announce or dbi-users unless I felt it was
important for us as a community. It is.
Please read it, or ideally watch and listen to it via the flash-with-audio.
Then do what you can.
Tim.
- Forwarded message from [EMAIL PROTECTED] -
Date: Wed, 14 Aug 2002 02:0
A thought: Has one of the recent security upgrades changed perl? I have DBI on my OS X
machine at home but I haven't used it for a month or two. I'll compare your @INC to
mine tonight and report back tomorrow, if no one else responds before then.
Do the old scripts still work?
-Chris
> -O
Kai Jendrian wrote:
> This sounds like an iteresting option which adds some additional
> overhead to the solution I had figured with the shell script but it
> gets rid of maintaining a second file with code. Good point!
Overhead should be the same: A shell script is just one type of
process s
Hello,
thanks for providing the answers!
>> Setting LD_LIBRARY_PATH after the program has started will not
>> affect that program. It's too late by then.
> One way around this, if you don't mind your program restarting on its
> own, is to do this. I believe it was someone on this list who poin
I am having a bit of difficulty with my perl scripts on MAC OSX laptop. I
have used perl scripts to populate sql tables as recently as last week.
This week when I tried to use another script I got an error.
*** Error msg.
Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwi
Kai Jendrian wrote:
>
>BEGIN {
>$ENV{'ORACLE_HOME'} = "/opt/ivas/oracle/product/8.1.6";
>$ENV{'LD_LIBRARY_PATH'} = $ENV{'ORACLE_HOME'} . "/lib";
>}
And Tim said:
> Setting LD_LIBRARY_PATH after the program has started will not
> affect that program. It's too late by then.
Hi,
Can we use the DBD::Oracle Perl Module to access a Oracle9i database?
I've read the documentation of DBD::Oracle on CPAN which mentions -
DBD::Oracle is a Perl module which works with the DBI module to provide access to
Oracle databases (both version 7 and 8).
rgds
Shankar S.
On Tue, Aug 13, 2002 at 04:18:58PM -0400, Kai Jendrian wrote:
>
> BEGIN {
> $ENV{'ORACLE_HOME'} = "/opt/ivas/oracle/product/8.1.6";
> $ENV{'LD_LIBRARY_PATH'} = $ENV{'ORACLE_HOME'} . "/lib";
> }
Setting LD_LIBRARY_PATH after the program has started will not
affect that progra
On Tue, Aug 13, 2002 at 06:32:45PM -0400, [EMAIL PROTECTED] wrote:
> >
> > Any thoughts on using the new DBI feature, specifying maxrows in a
> > fetchall_arrayref?
> >
> > If I use something like
> >
> > while ( my $array_ref=$sth->fetchall_arrayref(undef, $maxfetch)) {
> > # ... do somethin
On Tue, Aug 13, 2002 at 04:34:34PM -0400, Jeff Boes wrote:
> On Tue, 2002-08-13 at 15:55, Tim Bunce wrote:
>
> > If you (or anyone else) is using DBI 1.29 then upgrade to 1.30.
>
> Anyone know if there are any issues for upgrading from 1.22 to 1.30?
> How urgently should I pursue this if things
21 matches
Mail list logo
