plsql_utility::generate_oracle_name (public)

 plsql_utility::generate_oracle_name [ -max_length max_length ] \
    [ -include_object_id include_object_id ] stem

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

Returns an object name of max_length characters, in lowercase, beginning with stem but without any unsafe characters. Only allowed characters are numbers, letter, underscore, dash and space, though the returned word will start with a letter. Throws an error if no safe name could be generated. To almost guarantee uniqueness, you can use the next object_id from acs_object_id_seq as the tail of the name we return.

Switches:

-max_length (optional, defaults to "30")

-include_object_id (optional, defaults to "f")

Parameters:

stem (required)

Author:

Michael Bryzek <mbryzek@arsdigita.com>

Created:

11/2000

Testcases:

No testcase defined.