Question

MySQL创建存储过程报错

，过程如下：
CREATE PROCEDURE NewProc (
IN IN_ID VARCHAR,
OUT OUT_NAME VARCHAR
)
BEGIN
SELECT
C_NAME INTO OUT_NAME ROM T_ITCAST_ORGAN_USER
WHERE
c_id = IN_ID;
END;
报错如下：
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' OUT OUT_NAME varchar)
BEGIN
SELECT C_NAME INTO OUT_NAME
ROM T_ITC' at line 1
请问这是什么原因啊？？

Answer 1

目测两个VARCHAR未指定大小，ROM写少了“F”

建议修改如下试一试：
CREATE PROCEDURE NewProc (
IN IN_ID VARCHAR(250),
OUT OUT_NAME VARCHAR(250)
)
BEGIN
SELECT
C_NAME INTO OUT_NAME FROM T_ITCAST_ORGAN_USER
WHERE
c_id = IN_ID;
END;