Front page | perl.dbi.users |
Postings from July 2006
Re: CURSOR WITH UPDATE
Thread Previous
From:
pDale
Date:
July 11, 2006 11:56
Subject:
Re: CURSOR WITH UPDATE
Message ID:
5494c3ae0607111154n545cc1fatddcc86a53364dbe7@mail.gmail.com
On 7/11/06, Jonathan Leffler <jonathan.leffler@gmail.com> wrote:
>
> On 7/11/06, pDale <pdalec@gmail.com> wrote:
> > From looking around with Google, it would APPEAR that you can
> > implement a cursor WITH UPDATE in DBI, but I have not been able to
> > find an example of that. Would anyone happen to have a bare-bones
> > code framework for such a thing?
>
> $sth->{CursorName} is a key part of it.
>
> See also the docs for DBD::Informix (http://search.cpan.org/) for an example
> - the POD has a section CURSORS FOR UPDATE that shows how to do it.
I should have mentioned I'm working with Oracle. I may have found a
way by working with cursors directly, using something very loosely
related to binding cursors:
<http://search.cpan.org/~pythian/DBD-Oracle-1.17/Oracle.pm#Binding_Cursors>.
Any other suggestions?
--
pDale Campbell
"The moment I let go of it,
Was the moment I got more than I could handle."
Thread Previous