|
CREATE FUNCTION SP_GET_ITEM_COUNT
(ARG_ITEM_ID IN NUMBER) RETURN NUMBER
IS SP_RESULT NUMBER;
BEGIN
SELECT COUNT(*)
INTO SP_RESULT
FROM ORDER_ITEMS
WHERE ITEM_ID = ARG_ITEM_ID;
RETURN (SP_RESULT);
END;
|
|
CREATE PROCEDURE SP_GET_ITEM_COUNT (@ITEM_ID INT)
AS SELECT COUNT(*) FROM ORDER_ITEMS
WHERE ITEM_ID = @ITEM_ID
|
|
CREATE PROCEDURE SP_GET_ITEM_COUNT (@ITEM_ID INT)
AS SELECT COUNT(*) FROM ORDER_ITEMS WHERE ITEM_ID = @ITEM_ID
|
|
CREATE PROCEDURE SP_GET_ITEM_COUNT (ITEM_ID_INPUT INT)
RETURNING INT;
DEFINE CNT INT;
SELECT COUNT(*) INTO CNT FROM ORDER_ITEMS WHERE ITEM_ID = ITEM_ID_INPUT;
RETURN CNT;
|
|
CREATE PROCEDURE SP_GET_ITEM_COUNT (IN ARG_ITEM_ID INT,
OUT SP_RESULT INT,
OUT SQLCODE_OUT INT )
LANGUAGE SQL
P1: BEGIN
-- Declare variables
DECLARE SQLCODE INT DEFAULT 0;
-- Declare handler
DECLARE EXIT HANDLER FOR SQLEXCEPTION
SET SQLCODE_OUT = SQLCODE;
SELECT COUNT(*) INTO SP_RESULT
FROM ORDER_ITEMS
WHERE ITEM_ID=ARG_ITEM_ID;
SET SQLCODE_OUT = SQLCODE;
END P1
|
|
CREATE PROCEDURE SP_GET_ITEM_COUNT
(IN ARG_ITEM_ID integer, OUT SP_RESULT integer)
BEGIN
SELECT COUNT(*)
INTO: SP_RESULT
FROM ORDER_ITEMS
WHERE ITEM_ID =: ARG_ITEM_ID;
END;
|