oracle的一个简单的存储过程

存储过程的设计

create or replace PROCEDURE     GETBYID( THEID IN NUMBER, THENAME OUT VARCHAR2, THEAGE OUT NUMBER) ASBEGIN  SELECT NAME,AGE INTO THENAME,THEAGE FROM FYF.STUDENT WHERE ID=THEID;END; --FYF.GETBYID;

存储过程的调用

DECLARETHEID NUMBER(10):=2;THENAME VARCHAR2(100);THEAGE NUMBER(10);BEGINfyf.GETBYID(THEID,thename,theage);Dbms_output.Put_line('ok');END;