database connection and DBIx::Class

morgon has asked for the wisdom of the Perl Monks concerning the following question:

Can someone please explain to me how to get a database-handle from DBIx::Class.

What I do is that I have some classes that get persisted via DBIx::Class, so I derive from DBIx::Class::Schema and call connect on it.

Later I want to call some PL/SQL (to interface with Oracle Advanced Queuing) and need a database-handle to prepare a query - so how can I get to that?

Many thanks!

Comment on database connection and DBIx::Class

Replies are listed 'Best First'.
Re: database connection and DBIx::Class by Arunbear (Prior) on Apr 21, 2009 at 15:19 UTC
`my $dbh = $schema_object->storage->dbh;` [download]	[reply] [d/l]
Re^2: database connection and DBIx::Class by morgon (Priest) on Apr 21, 2009 at 16:27 UTC
Thanks!	[reply]