The DBI doc's seem to indicate that multiple values can be
returned from an insert query.
Q:
insert into foo
( bar bletch )
values
( bar$seq.nextval, bletch$seq.nextval )
returning
...
I've tried variations on "( bar, bletch ) into (?,?)" with
and wit
Juan,
The problem is your usage of "$sth->rows". You aren't
guaranteed to know how many rows are available before
you read them, so your example doesn't really show whether
data was available or not. Here is a snip from "perldoc DBI":
$rv = $sth->rows;
Returns the number of
Hi,
I have a problem trying to make a few queries work with parameter binding:
This code works fine:
use DBI;
use DBD::Oracle qw(:ora_types);
my $dbh = DBI->connect($dsn,$user,$password);
my $sth = $dbh->prepare('SELECT * FROM price WHERE id = 1');
$sth->execute();
my ($id,$price) = $sth->fetch
You need to look at metalink docs 230691.1, 252217.1. There is also another on
for RH 2.1. One of these will work for RH 9.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Maldonado, Daniel CW2 CTARNG [mailto:[EMAIL PROTECTED]
Sent: Mon 1/31/2005 1:24 PM
To:
While installing DBD::Oracle I got the following errors:
t/40ph_type.Can't load
'/root/.cpan/build/DBD-Oracle-1.16/blib/arch/
auto/DBD/Oracle/Oracle.so' for module DBD::Oracle:
/opt/oracle/product/9.2.0/lib
/libclntsh.so.9.0: undefined symbol: __cmpdi2 at
/usr/lib/perl5/5.8.0/i386-linu
Hello James:
This is from $SYBASE/OCS-12.0/include/cspublic.h:
#define CS_CMD_DONE(CS_INT)4046
So definitions are inherited from Sybase open client.
regards,
David
--- "Anderson, James H (Company IT)"
<[EMAIL PROTECTED]> wrote:
> What is the meaning of result type 4046? I'ts not
>
What is the meaning of result type 4046? I'ts not documented in
DBD::Sybase.
Thanks,
Jim
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
On 01/31/2005 04:52 AM, Manoj Kumar said:
1. From where I can get JPL source is any exact location because I got a lot
of packages with name JPL . ?
2. Is JPL a part of Perl or it's a third party module. ?
Looking forward for nice response from perl community .
http://
Thanks for the information.
Tim.
On Mon, Jan 31, 2005 at 09:25:32AM +0100, csg wrote:
> Hello!
>
> I'm reacting to an old message:
> http://www.nntp.perl.org/group/perl.dbi.users/24851
> (alternate link: http://www.mail-archive.com/dbi-users@perl.org/msg23002.html)
>
> I had got a similar probl
Hi folks,
I have an application talking to an Oracle 8i DB via DBI. As a test we
shutdown the network interface to see how the applcation responds and it
hangs for minutes. What we'd like is to detect the problem pretty well
immediately. How can this be done?
Is there something similar to
Hi ,
I 've some questions regarding perl . Please check it.
1. From where I can get JPL source is any exact location because I got a
lot
of packages with name JPL . ?
2. Is JPL a part of Perl or it's a third party module. ?
Looking forward for nice response
file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.94.tar.gz
size: 41994 bytes
md5: 88531f231c006c55328a8f355cb5325d
Changes:
Reworked db/st handle attributes:
- fetching all the data of a SELECT sets Active off
- dropped the RowsInCache attribute (ADO doesn't provide this
informat
Hello!
I'm reacting to an old message:
http://www.nntp.perl.org/group/perl.dbi.users/24851
(alternate link: http://www.mail-archive.com/dbi-users@perl.org/msg23002.html)
I had got a similar problem - it seems to me. Environment:
- Windows XP
- Perl 5.8.6 (MinGW compiled)
- DBI 1.46
- DBD::Oracle
13 matches
Mail list logo
