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:

• db_exec_plsql

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.