小白今天在linux环境刷一个数据库的Precedure,出现了如下报错:
SP2-0042: unknown command "AS" - rest of line ignored.
SP2-0734: unknown command beginning "v_WSJA ..." - rest of line ignored.
SP2-0734: unknown command beginning "v_WSJB..." - rest of line ignored.
SP2-0734: unknown command beginning "v_WSJC..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
v_wsj_name := 'LISTLOG_' || to_char(sysdate + 1,'yyyymmdd');
*
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00201: identifier 'v_WSJA' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
ORA-06550: line 4, column 3:
PLS-00201: identifier 'v_WSJB' must be declared
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
ORA-06550: line 6, column 65:
PLS-00201: identifier 'v_WSJC' must be declared
ORA-06550: line 6, column 3:
PL/SQL: Statement ignored
小白很着急,来来回回看了sql脚本很多遍,没什么异常,看到第3遍的时候,终于发现了疑点:
--???é?¤?????oè?¨ (这是中文注释,但是linux不识别中文,于是成为乱码)
CREATE OR REPLACE PROCEDURE P_WSJ_PRECEDRE
AS
v_WSJA VARCHAR2(100);
v_WSJB VARCHAR2(2000);
v_WSJC VARCHAR2(100);
BEGIN
解决办法:
将sql语句中的所有的中文注释全改成英文注释,就可以了。
总结:
在linux环境刷sql脚本的时候,应该注意两点:
1. sql文本的格式必须是UTF-8 无bom头
2. 没有中文注释