[CDBI] Re: Sequences in Class::DBI?

Rod McChesney rod.mcchesney at gmail.com
Thu Apr 27 20:12:26 BST 2006


> FYI, that's already in Class::DBI::Oracle.

Right, that's where I pulled it from. IIRC that module does some other
data-dictionary stuff that I did not want, which is why I didn't use
it.

> If you use that as your base
> class, then it's done for you automatically and you can then use CDBI's
> _next_in_sequence() method.

Cool, I didn't know about that call.

Thx,

Rod

On 4/27/06, Edward J. Sabol <sabol at alderaan.gsfc.nasa.gov> wrote:
> Rod McChesney wrote:
> > Note that you can also do this generically for Oracle in a your CDBI base
> > class:
> >
> > __PACKAGE__-> set_sql(Nextval => 'SELECT %s.NEXTVAL from DUAL');
>
> FYI, that's already in Class::DBI::Oracle. If you use that as your base
> class, then it's done for you automatically and you can then use CDBI's
> _next_in_sequence() method.
>
> Hope this helps,
> Ed
>
> _______________________________________________
> ClassDBI mailing list
> ClassDBI at lists.digitalcraftsmen.net
> http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
>




More information about the ClassDBI mailing list