plsql_utility::object_type_exists_p (public)

 plsql_utility::object_type_exists_p object_type

Defined in packages/acs-subsite/tcl/plsql-utility-procs.tcl

Returns 1 if the specified object_type exists. 0 otherwise.

Parameters:

object_type

Author:

Michael Bryzek <mbryzek@arsdigita.com>

Created:

11/2000

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

Testcases:

No testcase defined.

Source code:

        return [db_string object_type_exists_p {
            select case when exists (select 1 from acs_object_types where object_type=:object_type)
                         then 1
                         else 0
                    end
            from dual
        }]

XQL Not present:

Generic, PostgreSQL, Oracle