CREATE OR REPLACE FUNCTION pr_user( p0 CHAR ) RETURN Types.cursor_type IS
rs Types.cursor_type; BEGIN OPEN rs FORSELECT us.approval_type_code AS us_approval_type_code FROM wbs_users us WHERE upper( us.username ) = upper( p0 );
return rs; END; Could someone lend me a hand here? Thanks in advance, -M@