最简单的例子:(以后逐步完善) CREATE OR REPLACE PROCEDURE prc_a_brehme11(in1 IN VARCHAR2 , out1 OUT VARCHAR2) IS BEGIN SELECT AAE001 INTO out1 FROM aa02 WHERE AAA010 = in1; END prc_a_brehme11;
最简单的例子:(以后逐步完善)CREATE OR REPLACE PROCEDURE prc_a_brehme11(in1 IN VARCHAR2 , out1 OUT VARCHAR2)IS BEGIN SELECT AAE001 INTO out1 FROM aa02 WHERE AAA010 = in1;END prc_a_brehme11;