[CDBI] Re: delete on table with multiple pks

Kingsley Kerce kingsley at kingsleysoftware.com
Fri Nov 25 23:18:38 GMT 2005


Jim -- You might try enabling DBI trace (search for "trace" and
"tracing" in `perldoc DBI').  Another approach is to run your code in
the Perl debugger, step into the delete call and Class::DBI's
internals, and see what's happening.

Kings

Jim Salladin writes:
 > Is there some more code can I provide to make this issue more
 > accessible for help?
 > 
 > Thanks.
 > 
 > On 11/24/05, Jim Salladin <jsalladin at gmail.com> wrote:
 > > Hi all,
 > >
 > > I could not find some info in the docs. I just want to delete an
 > > object that is instantiated with a hash of two primary keys. I tried
 > > this:
 > > TableClass->retrieve(%pks)->delete;
 > >
 > > The error I get is this:
 > > Can't delete 1/3: DBD::Oracle::st execute failed: called with 1 bind
 > > variables when 2 are needed.
 > >
 > > The retrieve is working fine, but the delete is not. Any hints to what I can do?
 > >
 > > Thanks!





More information about the ClassDBI mailing list