nstrate the problems I am
> having binding cursors. In my actual code, the SQL statement is "SELECT
> product_id, product_xml FROM product", where product_xml is a CLOB, up to
> 500K in size. There are just over 21 millions records in the table, and some
> of the products h
Perhaps I should have been more specific when I said that "don't use
cursors" isn't a viable solution. The code below isn't the actual code that
I am trying to run, it is a simple example to demonstrate the problems I am
having binding cursors. In my actual code, the
if(defined($row[0])){
print "result: $row[0]\n";
}
}
print "done\n";
-Original Message-
From: Doug Johnson [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 11:40 AM
To: '[EMAIL PROTECTED]'
Subject: binding cursors
I'm sorry to brin
I don't see why you need a cursor,
the while (@row = $sth->fetchrow_array) will only fetch
a row at a time.
> $sth = $dbh->prepare(q{
> BEGIN OPEN :cursor FOR
> SELECT c_client_name
> FROM client;
> END;
> });
> my $st
I'm sorry to bring this up again - it has been covered before on the list,
but surprisingly nobody has come up with a solution.
If anyone has come up against this problem and has been able to solve it, or
even if you were unable to solve it, I'd love to hear from you!
Oh, and the solution: 'don'
On Thu, Aug 16, 2001 at 01:49:28PM -0700, Rob McMillin wrote:
> Tim Bunce wrote:
>
> > Try a $update->bind_param_inout(..., { ora_type => ORA_RSET }) so
> > oracle knows you're passing a cursor. Use trace to see more detail.
>
> Okay, specifics? While I got the select to work okay, I have yet t
Tim Bunce wrote:
> Try a $update->bind_param_inout(..., { ora_type => ORA_RSET }) so
> oracle knows you're passing a cursor. Use trace to see more detail.
Okay, specifics? While I got the select to work okay, I have yet to see
a working example of UPDATE ... WHERE CURRENT OF in Oracle using DBI
Try a $update->bind_param_inout(..., { ora_type => ORA_RSET })
so oracle knows you're passing a cursor. Use trace to see more detail.
Tim.
On Wed, Aug 15, 2001 at 06:14:28PM -0700, Rob McMillin wrote:
> Revisions:
>
> Oracle 8.1.7.1.1 (8i release 3)
> RedHat 6.2
> Perl 5.6.0
> DBD::Oracle 1.07
Revisions:
Oracle 8.1.7.1.1 (8i release 3)
RedHat 6.2
Perl 5.6.0
DBD::Oracle 1.07
I'm trying to bind a cursor so I can use the "FOR UPDATE OF" clause to
do updates and deletions. However, I can't even get the select working
correctly! Here's my Perl code:
#!/usr/bin/perl
use DBD::Oracle qw(:
to the wrong list. I appologize for the mixup.
>
> -Original Message-----
> From: Duncan, Mike
> Sent: Wednesday, April 04, 2001 11:24 AM
> To: '[EMAIL PROTECTED]'
> Subject: Binding Cursors using DBD::Oracle
>
> This topic may have been discussed earlier, but I
I may have sent this to the wrong list. I appologize for the mixup.
-Original Message-
From: Duncan, Mike
Sent: Wednesday, April 04, 2001 11:24 AM
To: '[EMAIL PROTECTED]'
Subject: Binding Cursors using DBD::Oracle
This topic may have been discussed earlier, but I cannot se
11 matches
Mail list logo
