package_plsql_args (private)

 package_plsql_args [ -object_name object_name ] package_name

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

Return a list of parameters expected to a plsql function defined within a given package and cache these per thread. Changes in the interface will require a server restart.

Switches:

-object_name (optional, defaults to "NEW")

The function name which we're looking up

Parameters:

package_name (required)

The package which owns the function

Returns:

list of parameters

Author:

Ben Adida <ben@openforce.net>

Created:

11/2001

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

Testcases:

No testcase defined.

Source code:

    return [acs::per_thread_cache eval -key acs-subsite.package_plsql_args($object_name-$package_name) {
        db_list select_package_func_param_list {}
    }]

Generic XQL file:

packages/acs-subsite/tcl/package-procs.xql

PostgreSQL XQL file:

<fullquery name="package_plsql_args.select_package_func_param_list">
    <querytext>
        select args.arg_name
        from acs_function_args args
        where args.function = upper(:package_name) || '__' || upper(:object_name)
      </querytext>
</fullquery>

packages/acs-subsite/tcl/package-procs-postgresql.xql

Oracle XQL file:

<fullquery name="package_plsql_args.select_package_func_param_list">
    <querytext>

	select args.argument_name
        from user_arguments args
        where args.position > 0
	  and args.object_name = upper(:object_name)
	  and args.package_name = upper(:package_name)
    
      </querytext>
</fullquery>

packages/acs-subsite/tcl/package-procs-oracle.xql