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.
in reply to Re^2: Calling Oracle StoredProc using Win32:ODBC
in thread Calling Oracle StoredProc using Win32:ODBC
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...