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 lower case, 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 (defaults to "30") (optional)

-include_object_id (defaults to "f") (optional)

Parameters:

stem

Author:

Michael Bryzek <mbryzek@arsdigita.com>

Created:

11/2000