储存过程入门07--储存过程

CREATE OR REPLACE PROCEDURE myproc(id (IN) varchar2)
IS
name varchar2(20);
BEGIN
SELECT books_name INTO name FROM books where books_id=id;
DBMS_OUTPUT.PUT_LINE(name);
END;
/

 

 

--调用储存过程

DECLARE
tid varchar2(10);
BEGIN
tid:='0001';
myproc(tid);
END;
/

 

EXECUTE myproc('0001');

 

 

 

 

CREATE OR REPLACE PROCEDURE myproc2(id varchar2,name out varchar2)
IS
BEGIN
SELECT book_name INTO name FROM books WHERE book_id=id;
END;
/

 

 

DECLARE
tid varchar2(10);
tname varchar2(10);
BEGIN
tid:='0001';
myproc2(tid,tname);
DBMS_OUTPUT.PUT_LINE(tname);
END;
/