谢谢,主要是第9行的错误。 PROCEDURE SCOTT.SP_FORMATDATE 编译错误错误:PLS-00103: 出现符号 "."在需要下列之一时: * & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between || member submultiset 符号 "*在 "." 继续之前已插入。 行:9 文本:strsql:='update '||v_tblnm||' SET launchdate = replace('||v_strslct||','.','')';错误:PLS-00103: 出现符号 "END"在需要下列之一时: . ( * @ % & = - + ; < / > at in is mod remainder not rem return returning <an exponent (**)> <> or != or ~= >= <= <> and or like like2 like4 likec between into using || multiset bulk member submultiset 符号 "END" 被忽略。 行:13 文本:end;
打断点 ,调试一下看看strsql变量的真实值是什么,你就应该知道错在哪里了。 strsql:='update '||v_tblnm||' SET launchdate =replace('||v_strslct||','.','')';我猜是少了引号。
第9行,replace函数里的点“.”前后是不是应该加上连接符“||”。
strsql:='update '||v_tblnm||' SET launchdate =replace('||v_strslct||',''.'','''')'; 另外 14行后面加个分号
PROCEDURE SCOTT.SP_FORMATDATE 编译错误错误:PLS-00103: 出现符号 "."在需要下列之一时:
* & = - + ; < / > at in is
mod remainder not rem <an exponent (**)> <> or != or ~= >= <=
<> and or like like2 like4 likec between || member
submultiset
符号 "*在 "." 继续之前已插入。
行:9
文本:strsql:='update '||v_tblnm||' SET launchdate = replace('||v_strslct||','.','')';错误:PLS-00103: 出现符号 "END"在需要下列之一时:
. ( * @ % & = - + ; < / >
at in is mod remainder not rem return returning
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between into using || multiset bulk member
submultiset
符号 "END" 被忽略。
行:13
文本:end;
strsql:='update '||v_tblnm||' SET launchdate =replace('||v_strslct||','.','')';我猜是少了引号。
另外 14行后面加个分号