1: function user_contact_summary (v_user_id IN integer)
2: return varchar
3: as
4: contact_row users_contact%ROWTYPE;
5: begin
6: select * into contact_row from users_contact where user_id = v_user_id;
7: IF contact_row.m_address = 'w' THEN
8: -- they prefer to receive mail at work
9: return contact_row.wa_line1 || ' ' || contact_row.wa_line2 || ' ' || contact_row.wa_city || ', ' || contact_row.wa_state || contact_row.wa_postal_code || ' ' || contact_row.wa_country_code;
10: ELSE
11: return contact_row.ha_line1 || ' ' || contact_row.ha_line2 || ' ' || contact_row.ha_city || ', ' || contact_row.ha_state || contact_row.ha_postal_code || ' ' || contact_row.ha_country_code;
12: END IF;
13: end user_contact_summary;
|