PowerCenter
- PowerCenter 10.5
- All Products
CREATE OR REPLACE FUNCTION GET_NAME_USING_ID ( nID IN NUMBER, outVAR OUT VARCHAR2) RETURN VARCHAR2 IS RETURN_VAR varchar2(100); BEGIN SELECT FIRST_NAME INTO outVAR FROM CONTACT WHERE ID = nID; RETURN_VAR := 'Success'; RETURN (RETURN_VAR); END; /