[Oracle Database] 프로시저 호출방법

Published: 2018-02-05 by 놀이터흙이제맛

• Categories:
• oracle 21

• Tags:
• dbms 32
• oracle 23
• sql 9

이런 프로시저가 있을 때:

  CREATE OR REPLACE PROCEDURE TEST_PROCEDURE_01(
    PARAMETER1 IN VARCHAR2,
    RESULT OUT VARCHAR2
  )
  AS
  BEGIN
    RESULT := 'BEGIN';
    DBMS_OUTPUT.PUT_LINE(PARAMETER1);
    RESULT := 'END';
  END;
  /

아래처럼 호출하면:

DECLARE
  RESULT VARCHAR2(100);
BEGIN
  TEST_PROCEDURE_BY_NORITER('hello!', RESULT);
  DBMS_OUTPUT.PUT_LINE(RESULT);
END;
COMMIT;

요로코롬 찍힌다:

  hello!
  END

끗.