例:
SET SERVEROUTPUT ON;
CREATE OR REPLACE PROCEDURE Procdemo(col1 IN varchar2,col2 out varchar2 ) AS
v_String1 VARCHAR2(50) := 'Hello World!';
BEGIN
col2 := col1||'is col2';
DBMS_OUTPUT.PUT_LINE(col1);
END Procdemo;
/declare
t_col2 varchar2(20);
begin
exec Procdemo into t_col2;
DBMS_OUTPUT.PUT_LINE('col2 is:'||col2);
end
/
SET SERVEROUTPUT ON;
CREATE OR REPLACE PROCEDURE Procdemo(col1 IN varchar2,col2 out varchar2 ) AS
v_String1 VARCHAR2(50) := 'Hello World!';
BEGIN
col2 := col1||'is col2';
DBMS_OUTPUT.PUT_LINE(col1);
END Procdemo;
/declare
t_col2 varchar2(20);
begin
exec Procdemo into t_col2;
DBMS_OUTPUT.PUT_LINE('col2 is:'||col2);
end
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货