随笔 - 589  文章 - 0 评论 - 116 trackbacks - 5

CREATE PROCEDURE MYPROC(IN P1 INT, IN P2 INT DEFAULT 1, OUT out1 DUMMY) AS
BEGIN
  out1 = SELECT :P1 + :P2 AS DUMMY FROM DUMMY;
END;

 

调用方式:

CALL MYPROC(3, 4,?);

or

CALL MYPROC(P1 => 3, out1 => ?)

posted on 2013-04-11 22:16  沧海-重庆  阅读(888)  评论(0编辑  收藏