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(: