On Tue, Aug 28, 2001 at 12:13:28PM +0100, Doug Johnson wrote:
> 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
cursors, but cannot do so on a RedHat
machine. This isn't a new problem, I am not the only person to have
experienced it, and it doesn't seem to be confined to just RedHat:
http:[EMAIL PROTECTED]/msg00078.html.
cheers,
doug.
-Original Message-
From: Jones Robert Contr 81 CS/SCK [ma
THE NEW CODE:
#!/usr/bin/perl -w
use DBI;
use DBD::Oracle qw(:ora_types);
print "connecting to database... ";
$dbh = DBI->connect('DBI:Oracle:blah', 'blah', 'blah') || die
$dbh->errstr;
$dbh->{RaiseError} = 1;
print "done!\n";
print "preparing the statement... ";
$sth = $dbh
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
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
