oracle function in out

Solutions on MaxInterview for oracle function in out by the best coders in the world

showing results for - "oracle function in out"
Jerónimo
30 Feb 2019
1CREATE OR REPLACE FUNCTION TESTME(A IN NUMBER, 
2                                  B OUT NUMBER, 
3                                  C IN OUT NUMBER) RETURN NUMBER IS
4BEGIN
5    B := A + 10;
6    C := C + A;
7    RETURN (100);
8END;
9/
10
11DECLARE
12    X NUMBER := 10;
13    Y NUMBER := 20;
14    Z NUMBER;
15BEGIN
16    Z := TESTME(X, Z, Y);
17    DBMS_OUTPUT.PUT_LINE('X: ' || X || '  Y: ' || Y ||   '  Z: ' || Z);
18    -- X: 10  Y: 30  Z: 100
19END;