3,494
社区成员




SQL> CREATE OR REPLACE PROCEDURE A(I OUT VARCHAR2,
2 J IN NUMBER,
3 K IN VARCHAR2) AS
4 BEGIN
5 I := TO_CHAR(J) || K;
6 END;
7 /
Procedure created
SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
2 v_i VARCHAR2(2000);
3 BEGIN
4 A(v_i,123,'ABC');
5 DBMS_OUTPUT.put_line(V_I);
6 END;
7 /
123ABC
PL/SQL procedure successfully completed
SQL>