tww
.tww_sys
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
get_default_values(field_name text)
Parameters
Name
Type
Mode
field_name
text
IN
Definition
DECLARE myrec record; BEGIN BEGIN SELECT value_obj_id::varchar(16) INTO myrec FROM tww_od.default_values WHERE fieldname = field_name; EXCEPTION WHEN NO_DATA_FOUND THEN RAISE WARNING 'Field name % not found in table tww_od.default_values. Returning NULL',field_name; RETURN NULL; END; RETURN myrec.value_obj_id; END;