oracle function in out code example
Example: oracle function in out
CREATE OR REPLACE FUNCTION TESTME(A IN NUMBER,
B OUT NUMBER,
C IN OUT NUMBER) RETURN NUMBER IS
BEGIN
B := A + 10;
C := C + A;
RETURN (100);
END;
/
DECLARE
X NUMBER := 10;
Y NUMBER := 20;
Z NUMBER;
BEGIN
Z := TESTME(X, Z, Y);
DBMS_OUTPUT.PUT_LINE('X: ' || X || ' Y: ' || Y || ' Z: ' || Z);
-- X: 10 Y: 30 Z: 100
END;