---1.建立-----
SET SERVEROUTPUT ON FORMAT WRAPPED
CREATE OR REPLACE PROCEDURE lot_num
(in_sex in TEST_CUR.SEX % TYPE)
AS
out_num NUMBER;
BEGIN
IF in_sex = '1' THEN
SELECT COUNT(sex) FROM TEST_CUR WHERE sex = '1';
dbms_output.put_line('NUMBER IS '|| out_num);
ELSE
SELECT COUNT(sex) FROM TEST_CUR WHERE sex = '0';
dbms_output.put_line('NUMBER IS '|| out_num);
END IF;
END lot_num;
---2.调用-----
---オブジェクト'XLACS_TRAN.LOT_NUM'が無効です
EXECUTE LOT_NUM('1');
---3.参数类型存储过程------
CREATE OR REPLACE PROCEDURE In_Out_Pro
(
in_num IN NUMBER, ---输入型参数
out_num OUT NUMBER ---输出型参数
) AS
BEGIN
out_num:= in_num * 2;
END In_Out_Pro;----结束处一定要有个;号码
CREATE OR REPLACE PROCEDURE In_Out_Pro2
(
in_out_num IN OUT NUMBER ---输入输出型参数
) AS
BEGIN
in_out_num:= in_out_num * 3;
END In_Out_Pro2;----结束处一定要有个;号码
DROP PROCEDURE IN_OUT_PRO;
DROP PROCEDURE IN_OUT_PRO2;