db_exec_plpgsql (private)
db_exec_plpgsql db statement_name pre_sql fname
Defined in packages/acs-tcl/tcl/01-database-procs.tcl
PostgreSQL only.
A helper procedure to execute a SQL statement, potentially binding depending on the value of the $bind variable in the calling environment (if set).
Low level replacement for db_exec which replaces inline code with a proc. db proc is dropped after execution. This is a temporary fix until we can port all of the db_exec_plsql calls to simple selects of the inline code wrapped in function calls.
emulation of plsql calls from oracle. This routine takes the plsql statements and wraps them in a function call, calls the function, and then drops the function. Future work might involve converting this to cache the function calls
This proc is private - use db_exec_plsql instead!
- Parameters:
- db (required)
- statement_name (required)
- pre_sql (required)
- fname (required)
- See Also:
- Testcases:
- No testcase defined.
