Re: Binding cursors: what's going wrong here?

2001-08-16 Thread Tim Bunce
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

Re: Binding cursors: what's going wrong here?

2001-08-16 Thread Rob McMillin
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

Re: Binding cursors: what's going wrong here?

2001-08-16 Thread Tim Bunce
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

Binding cursors: what's going wrong here?

2001-08-15 Thread Rob McMillin
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(: