Search This Blog

Tuesday 3 January 2017

Call function inside stored procedure oracle

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