package_function_p (private)

 package_function_p -object_name object_name package_name

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

Switches:
-object_name
(required)
Parameters:
package_name
Returns:
true if the package's object is a function.

Partial Call Graph (max 5 caller/called nodes):
%3 package_exec_plsql package_exec_plsql (public) package_function_p package_function_p package_exec_plsql->package_function_p db_0or1row db_0or1row (public) package_function_p->db_0or1row

Testcases:
No testcase defined.
Source code:
    return [acs::per_thread_cache eval -key acs-subsite.package_function_p($object_name-$package_name) {
        db_0or1row function_p ""
    }]
Generic XQL file:
packages/acs-subsite/tcl/package-procs.xql

PostgreSQL XQL file:
<fullquery name="package_function_p.function_p">
    <querytext>
         select 1
      </querytext>
</fullquery>

<fullquery name="package_function_p.function_p">
    <querytext>
        select 1 from dual
      </querytext>
</fullquery>
packages/acs-subsite/tcl/package-procs-postgresql.xql

Oracle XQL file:
<fullquery name="package_function_p.function_p">
    <querytext>

	 select 1
	 from dual
         where exists (select 1
	               from user_arguments
		       where rtrim(package_name) = upper(:package_name)
		       and rtrim(object_name) = upper(:object_name)
		       and position = 0)
    
      </querytext>
</fullquery>
packages/acs-subsite/tcl/package-procs-oracle.xql

[ hide source ] | [ make this the default ]
Show another procedure: