in reply to Re^2: No stored procedure bashing on my watch!
in thread Recoding a multi-sql-statement storedProc transaction in a script

don't use any SQL code in your applications (except for calling stored procedures). Ever.

Shameless plug: DBIx::ProcedureCall makes Perl wrappers for stored procedures, eliminating the SQL to call them from your application source code as well. Only works for Oracle at the moment, though (contributions for other DBMS always welcome).

  • Comment on Re^3: No stored procedure bashing on my watch!

In Section Seekers of Perl Wisdom