First I'd guess he's using DBI w/ DBD::ODBC or DBD::Oracle, I know I haven't used Win32::ODBC in quite some time.

I'd also guess that 'apps.package_name' is related to the name space that the stored proc is in. For those details you'll want to talk to your DBA.

Also the 'bind' statements are related to the parameters. Since you don't want to use parameters, you can safely ignore the binds...

TJD