Step 1:- Create function
CREATE OR REPLACE FUNCTION FUNTEST RETURN VARCHAR2 AS
BEGIN
RETURN 'HELLO WORLD';
END;
Step 2:- Create store procedure
CREATE OR REPLACE PROCEDURE USP_CALLFUNTEST AS
P_VALUE VARCHAR2(500);
BEGIN
P_VALUE := FUNTEST();
DBMS_OUTPUT.PUT_LINE(P_VALUE);
END;
No comments:
Post a Comment