日期:2014-05-17 浏览次数:20742 次
CREATE OR REPLACE PROCEDURE P_WYB_FIND_NAME(ID IN NUMBER,
NAME OUT VARCHAR2) AS
BEGIN
SELECT T.NAME INTO NAME FROM INFO_STU_1 T WHERE T.ID = ID;
END;
DECLARE
LOCAL_ID INFO_STU_1.ID%type := 2;
LOCAL_NAME INFO_STU_1.NAME%TYPE;
BEGIN
P_WYB_FIND_NAME(LOCAL_ID, LOCAL_NAME);
DBMS_OUTPUT.PUT_LINE(LOCAL_ID || '/' || LOCAL_NAME);
END;