Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION getEmail(
- pidm int,
- emalCode1 VARCHAR2,
- emalCode2 VARCHAR2,
- emalCode3 VARCHAR2,
- prefInd VARCHAR2 -- does nothing
- )
- RETURN VARCHAR2 IS
- v_pidm int;
- v_email VARCHAR2(256);
- v_pref VARCHAR2(2);
- BEGIN
- IF prefInd = 'Y' THEN
- v_pref := 'Y';
- ELSE
- v_pref := '%';
- END IF;
- SELECT goremal_email_Address INTO v_email FROM
- (
- SELECT goremal_email_address
- FROM
- goremal
- WHERE goremal_pidm = pidm
- AND goremal_status_ind = 'Y'
- AND goremal_preferred_ind LIKE v_pref
- ORDER BY DECODE(goremal_emal_code,emalCode1,1,emalCode2,2,emalCode3,3,99) ASC
- ) WHERE ROWNUM = 1;
- RETURN v_email;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement