DROP PROCEDURE IF EXISTS tivo_hybrid.register_end;
CREATE PROCEDURE tivo_hybrid.`register_end`(
IN i_serial VARCHAR(100),
OUT o_result VARCHAR(50)
)
BEGIN
DECLARE dbErr INT DEFAULT 0;
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SET dbErr = -1;
SET @q_serial = i_serial;
SET @q_result = 'OK';
IF (@q_serial IS NULL OR @q_serial = '') THEN
SET @q_result = 'ERR: NULL argument';
ELSE
UPDATE tivo_serial_master SET end_fg = 'OK' WHERE serial = @q_serial;
IF dbErr < 0 THEN
SET @q_result = 'ERR: update end_fg';
ELSE
SET @q_result = 'OK';
END IF;
END IF;
SET o_result = @q_result;
SELECT o_result;
END;
´Ü¼øÇÕ´Ï´Ù. º°°Å ¾ø¾î¿ä.
PCÂÊ¿¡¼ ¸¶Áö¸·À¸·Î "´Ù Àß Çß´Ù". ¶ó°í ½á³Ö´Â°Çµ¥ PC¿¡¼
SQLDirectExecute ·Î À̰ÍÀ» È£ÃâÇßÀ»¶§ ¸ØÃä´Ï´Ù. ÀÌ ÇÔ¼ö¿¡¼ ³ª¿ÀÁö¸¦ ¾Ê¾Æ¿ä.
Timeoutµµ ¼³Á¤µÇÀִµ¥ ¸®ÅÏ ÀÚü¸¦ ¾ÈÇÕ´Ï´Ù.
¹ß»ýºóµµ´Â Á» ·»´ýÀε¥, 300¹øÂëÀ϶§µµ ÀÖ°í, 8000¹ø ÂëÀ϶§µµ ÀÖ¾î¿ä.
¾Æ¹«¸®ºÁµµ À̰Թ®Á¦´Â ¾Æ´Ñ°Å °°Àºµ¥ PCÂʵµ ³ª¸§ ¿À·¡ ½á¿À´ø ÄÚµå¶ó³×¿ä.
Á¶±Ý¸¸ ºÁÁÖ¼¼¿ä..
Âü, ¸¶Áö¸· SELECT´Â @o_result·Îµµ ÇØºÃ¾î¿ä. ¸¶Âù°¡Áö¿¹¿ä.