mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0

Connection id:          94

Current database:       saga

Current user:           saga@localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server version:         5.0.27-log Source distribution

Protocol version:       10

Connection:             Localhost via UNIX socket

Server characterset:    euckr

Db     characterset:    euckr

Client characterset:    latin1

Conn.  characterset:    latin1

UNIX socket:            /tmp/mysql.sock

Uptime:                 15 days 15 hours 10 min 15 sec

Threads: 3  Questions: 2243  Slow queries: 0  Opens: 227  Flush tables: 1  Open tables: 23  Queries per second avg: 0.002

--------------

mysql 버전이구요..

centos에 설치되어 있습니다.

생성하려는 함수는 아래와 같습니다.

CREATE FUNCTION getCodeName(V_CODE_GROUP VARCHAR(3), V_CODE_DETAIL VARCHAR(3)) RETURNS VARCHAR(200)

BEGIN

    DECLARE V_CODENAME VARCHAR(200);

    SELECT CODE_NAME INTO V_CODENAME FROM TB_CODE WHERE CODE_GROUP = V_CODE_GROUP AND CODE_DETAIL = V_CODE_DETAIL AND USE_YN = 'Y';

    RETURN V_CODENAME;

END;

에러는 아래와 같이 발생 합니다.

MySQL Database Error: 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 'RETURN V_CODENAME' at line 1

도움 부탁드립니다.