In PL/SQL, how to call an Oracle stored procedure?

8 months ago

Ava Mitchell

2 minutes

In PL/SQL, calling an Oracle stored procedure can be achieved by following these steps:

Carry out
Give me a ring
Prints a line of output to the console.

Here is a simple example:

-- 创建一个存储过程
CREATE OR REPLACE PROCEDURE my_procedure (p_param1 IN VARCHAR2, p_param2 OUT VARCHAR2)
IS
BEGIN
  p_param2 := 'Hello ' || p_param1;
END;
/

-- 在PL/SQL中调用存储过程
DECLARE
  v_param1 VARCHAR2(50) := 'World';
  v_param2 VARCHAR2(50);
BEGIN
  my_procedure(v_param1, v_param2);
  DBMS_OUTPUT.PUT_LINE('Output: ' || v_param2);
END;
/

In the example above, we first created a stored procedure called my_procedure. Then, we called this stored procedure in a PL/SQL block and used DBMS_OUTPUT.PUT_LINE to output the stored procedure’s output parameters. You can modify the stored procedure’s parameters and logic according to your specific needs.