package_exec_plsql (public)

 package_exec_plsql [ -var_list var_list ] package_name object_name

Defined in packages/acs-subsite/tcl/package-procs.tcl

Calls a pl/[pg]sql proc/func defined within the object type's package. Use of this Tcl API proc avoids the need for the developer to write separate SQL for each RDBMS we support.

Switches:

-var_list (optional)

A list of pairs of additional attributes and their values to pass to the constructor. Each pair is a list of two elements: key => value

Parameters:

package_name (required)

The PL/[pg]SQL package

object_name (required)

The PL/[pg]SQL function within the package

Returns:

empty string for procs, function return value for funcs

Example:

    set var_list [list  [list group_id $group_id]]

    package_exec_plsql -var_list $var_list group delete

    

Author:

Don Baccus <dhogaza@pacifier.com>

Created:

12/31/2003

Testcases:

auth_authenticate