CALL (手続ã??) æ–‡

CALL (手続ã??)æ–‡ã?«ã‚ˆã‚Šæ‰‹ç¶šã??を呼ã?¶ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚ 手続ã??ã?¸ã?®å‘¼ã?³å‡ºã?—ã?¯å€¤ã‚’è¿”ã?—ã?¾ã?›ã‚“。

æ§‹æ–‡

CALL 手続å?? ( [ å¼? [, å¼?]* ] )

例

CREATE PROCEDURE SALES.TOTAL_REVENUE(IN S_MONTH INTEGER,
IN S_YEAR INTEGER, OUT TOTAL DECIMAL(10,2))
PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME 
'com.acme.sales.calculateRevenueByMonth';
CALL SALES.TOTAL_REVENUE(?,?,?);