Oracle9iAS Portal Developer Kit

validate_system_var_name procedure

Contained in package wwctx_api.

Call this function to validate a given system variable name. If the given name is not valid, an exception is raised.

procedure validate_system_var_name
(

p_system_var_name in system_var_name_type

);

Version: Oracle9iAS Portal 9.0.2 or later

Parameters:

p_system_var_name

The system variable name.

Valid names include all the SYSTEM_VAR_ constants, as well as any name in the set returned by get_system_var_names.

Note: Names are not case sensitive.

Datatype: in system_var_name_type

Exceptions:

If the given system variable name is not recognized, SYSTEM_VAR_NAME_EXCEPTION is raised.

Example:

l_system_var_names wwctx_api.system_var_names_type;
l_system_var_name wwctx_api.system_var_name_type;

l_system_var_names := wwctx_api.get_system_var_names;
for i in 1..l_system_var_names.count loop

l_system_var_name := l_system_var_names(i);
wwctx_api.validate_system_var_name
(

p_system_var_name => l_system_var_name

);
...

end loop;

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio