FYI.this worked fine for DBD::Oracle 1.12 also. Many thanks to Mr.
Eisenman and Mr. Bunce for their generous help. I truly appreciate it.
Regards,
Bill Benner
-Original Message-
From: Richard_Eisenman [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 24, 2001 1:11 PM
To: [EMAIL PR
Your memory serves you well. I had to dig pretty deeply in the installer
(plus had to turn on the option to show all packages including required
dependencies just to figure out it wasn't installed). I sadly almost
installed the server before figuring out that it was possible to install
the dev
Hi Folks,
If memory serves, one thing I had to do when installing the Oracle
database client (and when I wanted to compile DBD::Oracle) was to take
particular care in ensuring the "Oracle9i Development Kit" was installed
(I don't believe it was included in the base installation).
I remember taki
I seem to be having problems installing DBD::Oracle with Oracle 9i
installed on Linux Mandrake 8.0 on a Pentium III. (I also can't seem
to get the Oracle 8.1.7 installer working either... argghh...).
I get this message:
Using DBI 1.20 installed in
/usr/lib/perl5/site_perl/5.6.0/i386-linux/a
Alzabo is a program and a module suite, with two core functions. Its first
use is as a data modelling tool. Through either a schema creation
interface or a perl program, you can create a set of schema, table,
column, etc. objects to represent your data model. Alzabo is also capable
of reverse eng
Thanks
"Sterin, Ilya" wrote:
>
> Well it depends, though nothing will hand unless there is a bug or you make
> it hang.
>
> If you set RaiseError => 1, then the program will exit on error in any
> subroutine. You can catch your errors using eval and therefore do anything
> you want when an er
Well it depends, though nothing will hand unless there is a bug or you make
it hang.
If you set RaiseError => 1, then the program will exit on error in any
subroutine. You can catch your errors using eval and therefore do anything
you want when an error is generated. I still don't see why you w
No, not a diffrent process but will the current process hang due to error in the
subroutine test1. Another example, if test1 had an infinite loop I would expect
$dbh process to remain open, right? I'm just polling the group to find out if
anyone writing code like this and what are the pit-fall :(
Not sure what you mean. You are reusing a global handle, if you mean will
there be a memory leak, no since everything is deallocated at end of
execution. Otherwise I am not exactly sure, why you would think that a
different process is created:-?
Ilya
> -Original Message-
> From: Anthon
if I have the following code
sub test {
$dbh =get_dbh;
test1($dbh,$somedata);
close($dbh);
}
sub test1 {
my ($dbh,$data)=@_;
#sql code
}
if the $sql code fails in subroutine "test1" does it causes a open process
since I defined $dbh as local?
Anthony Scott
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, Sep 24, 2001 at 02:36:48PM +0200, Anders Hultman wrote:
> I've successfully installed DBI-1.20 but it's when I try to install
> DBD-Oracle-1.12 it all fails. I have installed what I thought was the whole
> Oracle client, but "perl Makefile.P
Folks,
How are you ?.
Is there any DBI(DBI-1.20) binary version available for the Solaris-8.
?.
Please advice me.
Thanks,
Srinivas.
On Mon, Sep 24, 2001 at 08:11:12AM -0600, Sterin, Ilya wrote:
> Ronald, but (not necessarily in this case, since it's a count(*) query), but
> for most others it will also return the first column selected and set it to
> undef if that column is NULL, so therefore it will also call the dbError()
>
Ronald, but (not necessarily in this case, since it's a count(*) query), but
for most others it will also return the first column selected and set it to
undef if that column is NULL, so therefore it will also call the dbError()
sub. The difference with this, is the count(*) returns something, (0+
First of all there's no need for double quotes around variable names.
Second PrintError is on by default and RaiseError prints errors unless you
have a __DIE__ handler.
So...
$dbh = DBI->connect($data_source, $username, $password, { RaiseError => 1,
AutoCommit => 1 });
>Subject: Cant create TC
On Sat, Sep 22, 2001 at 06:37:32PM -0500, [EMAIL PROTECTED] wrote:
> this one seems to puzzle me on how to avoid an unnecessary db error. I
> need to run a tally count on a couple tables, and if there isn't any data
> in the table it displays the dbError, altho there isn't technical any
> syntax
I get this error msg after the following statement:
$dbh = DBI->connect("$data_source", "$username", "$password", { RaiseError
=> 1, PrintError => 1, AutoCommit => 1 });
$username and $password are set and
$datasource = "DBI:mysql:$db:$dbhost:dbport";
where $db, $dbhost and $dbport are set as
> -Original Message-
> From: Steven Vetzal [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 23, 2001 7:38 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Avoid Error if no results
>
>
> > > You should replace:
> > >
> > > $expire = $dbh->selectrow_arra
I've written Perl scripts that access MySQL databases through DBI and the
appropriate driver for several years, and now I'm about to do the same but
this time with an Oracle database. I thought it should be easy as typing
"make", but me and a colleague has struggled with this for three days now
Hi!
Apparently I'm unable to build perl from sources as well, as the 'ld' linker
as well provides some errors while making configure.
The compiler is able to compile a basic programme, but linker never gets any
success in linking it :(
Anybody has any ideas?
--
Vladimir Lazarenko
VL824-RIPE
--
-Original Message-
From: Mark Buckle
Sent: 24 September 2001 10:41
To: '[EMAIL PROTECTED]'
Subject: FW: Collections of handles
Are there any plans to add/make available as a collection, the list of
current open statement handles for an open database handle?
'Kids' just seems to h
To my knowledge, no one has built DBI (with DBD-Oracle) successfully with
GCC on HPUX.
For sure, you need to build perl from sources or it be unlikely to work.
If you succeed, please let me know what you did and I will add the
information to the README.hpux file.
Lincoln
-Original Message-
Hi!
I'm trying to compile DBI 1.20 on HPUX 11.00. I have installed gnu compiler
on it, but apparently I get errors.
Perl was installed from a depot dile, as well as gnu compiler...
Can anyone suggest something?
Dying without Perl::DBI :((
THanks in advance
Here is the errors transcript:
bash-2
On Sun, Sep 23, 2001 at 02:32:47PM -0700, Bill Benner wrote:
> Hello,
>
> I've done my absolute best to figure this out without asking for help, I've
> spent at least 12 hours trying everything. But no luck, so here goes.
Notice that Makefile.PL says
Unable to interpret Oracle oci buil
Are there any plans to add/make available as a collection, the list of
current open statement handles for an open database handle?
'Kids' just seems to hold the total number of handles. Presumably if this
information is available then a collection of handles
could be made available. (I'm as
Are there any plans to add/make available as a collection, the list of
current open statement handles for an open database handle?
'Kids' just seems to hold the total number of handles. Presumably if this
information is available then a collection of handles
could be made available. (I'm assumi
All are examples of why using RaiseError is a good idea!
Tim.
On Sun, Sep 23, 2001 at 12:27:31PM -0400, Sterin, Ilya wrote:
>
>
> > -Original Message-
> > From: Steven Vetzal [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, September 23, 2001 8:06 AM
> > To: [EMAIL PROTECTED]; [EMAIL PROTE
On Fri, Sep 21, 2001 at 04:36:13PM -0400, Greg Stark wrote:
>
> I was about to upgrade our installation when I noticed this in the changelog.
>
> Tim Bunce <[EMAIL PROTECTED]> writes:
>
> > Changes in DBD::Oracle 1.09 27th August 2001
> >
> > Changed behaviour when OCIStmtExecute() returns
28 matches
Mail list logo
