Is there a way in DBI to get a $sth->rows count, when selecting to a
temporary table?
In this code I get a proper count from the SELECT, but the SELECT INTO
TEMPORARY TABLE returns -1.
$dbh = DBI->connect(...);
$sth = $dbh->prepare("SELECT data,name FROM saved_searches order by
random()");
Martin Gainty wrote:
any reason why you want to 'describe' before the executing the statement?
thanks
Martin
_
I'm not wishing to put words in Merijn's mouth but having attempted to
write a perl app which worked with a number of DBDs I have some
experience of how difficult this is.
On Thu, 30 Oct 2008 16:23:29 -0400, Martin Gainty <[EMAIL PROTECTED]>
wrote:
> any reason why you want to 'describe' before the executing the statement?
Did you see the original problem description?
When "w_test" is a blob/binary/bytea, this:
--8<---
my $stu = $dbh->prepare (qq;
update w_te
On Thu, Oct 30, 2008 at 09:00:38PM +0100, H.Merijn Brand wrote:
> On Thu, 30 Oct 2008 15:06:00 -0400, John Scoles <[EMAIL PROTECTED]>
> wrote:
>
> > Again Tim and his wisdom of the ages comes to the rescue.
> >
> > A quick look at DBD::ORacle and his suggestion will take only a few
> > seconds t
any reason why you want to 'describe' before the executing the statement?
thanks
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This transmission is of a confide
On Thu, 30 Oct 2008 15:06:00 -0400, John Scoles <[EMAIL PROTECTED]>
wrote:
> Again Tim and his wisdom of the ages comes to the rescue.
>
> A quick look at DBD::ORacle and his suggestion will take only a few
> seconds to do.
Well, it was like I suggested, but it still does not remove the need
fo
Again Tim and his wisdom of the ages comes to the rescue.
A quick look at DBD::ORacle and his suggestion will take only a few
seconds to do.
Looks like a patch coming up in the AM.
cheers
John Scoles
Tim Bunce wrote:
On Thu, Oct 30, 2008 at 10:43:22AM -0400, John Scoles wrote:
I will loo
On Thu, Oct 30, 2008 at 10:43:22AM -0400, John Scoles wrote:
> I will look into it tomorrow Merijn suggested something like dbd_blob or
> dbd_binay at the dbd level
>
> so we could just do this
>
> $s->bind_param (":p1","foo\nbar", {TYPE=>dbd_blob});
>
> and let the DBD figure out what dbd_blob
I will look into it tomorrow Merijn suggested something like dbd_blob or
dbd_binay at the dbd level
so we could just do this
$s->bind_param (":p1","foo\nbar", {TYPE=>dbd_blob});
and let the DBD figure out what dbd_blob is for them
The tack I am looking at is some sort of flag where you tell
On Thu, 30 Oct 2008 15:25:05 +0100, Mark Lawrence <[EMAIL PROTECTED]>
wrote:
> On Thu Oct 30, 2008 at 02:34:55PM +0100, H.Merijn Brand wrote:
> > On Thu, 30 Oct 2008 09:06:52 -0400, John Scoles <[EMAIL PROTECTED]>
> > wrote:
> >
> > > Ok looks like you need to use bind_param with a Blob and also
On Thu Oct 30, 2008 at 02:34:55PM +0100, H.Merijn Brand wrote:
> On Thu, 30 Oct 2008 09:06:52 -0400, John Scoles <[EMAIL PROTECTED]>
> wrote:
>
> > Ok looks like you need to use bind_param with a Blob and also tell
> > DBD::Oracle is is a Blob
> >
> > ie
> >
> > $stu->bind_param(":p1","foo\nba
On Thu, 30 Oct 2008 09:06:52 -0400, John Scoles <[EMAIL PROTECTED]>
wrote:
> Ok looks like you need to use bind_param with a Blob and also tell
> DBD::Oracle is is a Blob
>
> ie
>
> $stu->bind_param(":p1","foo\nbar",{ ora_type => ORA_BLOB });
This is a disaster to all portability!
My scripts
Ok looks like you need to use bind_param with a Blob and also tell
DBD::Oracle is is a Blob
ie
$stu->bind_param(":p1","foo\nbar",{ ora_type => ORA_BLOB });
The code below works
#!/usr/local/bin/perl
use DBI;
use DBD::Oracle qw(:ora_types);
my $dbname = 'first10g';
my $dbuser = 'tbo';
my $d
On Thu, Oct 30, 2008 at 8:35 AM, H.Merijn Brand <[EMAIL PROTECTED]> wrote:
> I don't understand what the error I get has to do with the executed code.
> Can someone enlighten me?
[...]
> $dbh->do (qq;
>create table w_test (
>c_test numeric (9),
>v_test numeric (4),
>s
I don't understand what the error I get has to do with the executed code.
Can someone enlighten me?
--8<---
use strict;
use warnings;
use DBI;
my ($user, $pass) = split m{/}, $ENV{ORACLE_USERID};
my $dbh = DBI->connect ("dbi:Oracle:", $user, $pass, { AutoCommit => 0 });
$dbh->do (qq;
create
15 matches
Mail list logo