in reply to PL/SQL code and Perl
By "PL/SQL" I'm assuming you're using Oracle. AFAIK, there's no (existing) way to implement Oracle's SQL extensions through DBI, although you have a couple options:
If nothing else, hit Google and start searching like mad. =)
Disclaimer: I've only worked Oracle as a programmer, not a DBA, and we weren't doing anything outside of your usual SELECT, INSERT, etc. So it's possible that I am missing the whole point, here.
Update: After perusing around for a bit, it appears that you can indeed use PL/SQL with DBI. You just prepare a query with the proprietary commands and send that through DBI to Oracle. Works the same as a standard query. I'm impressed. {g}
|
|---|