存储过程入门

--建立测试数据:create table BOOK(编号 number(10),书名 varchar2(20),价格 varchar2(20))insert into BOOK values(100,'aa','88.77')select * from BOOK--建立存储过程:create or replace procedure query_BOOK(name IN OUT NUMBER,MY_BOOK OUT VARCHAR2,MY_BOOK2 OUT VARCHAR2) isbeginselect 编号 ,书名,价格 INTO name,MY_BOOK,MY_BOOK2 from BOOK where 编号=name;  end query_BOOK;--调用存储过程:declare v_name number(10); v_my_book varchar2(50); v_my_book2 varchar2(20);begin  v_name := 100;  query_BOOK(v_name,v_my_book,v_my_book2); --调用存储过程  dbms_output.put_line('v_name is: '||v_name);  dbms_output.put_line('v_my_book is: '||v_my_book);    dbms_output.put_line('v_my_book2 is: '||v_my_book2);  exception  when others then  dbms_output.put_line(sqlerrm);end;