Home
The Toolkit for Online Communities
17596 Community Members, 1 member online, 2393 visitors today
Log In Register
OpenACS Home : ACS API Browser : plsql_utility::generate_oracle_name

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
[ show source ]
Show another procedure: