ORACLE SQLPLUS 创建过程语法错误。
写了个最简单的,仍报错。在网上搜到一些类似的报错,但解决方法对我的不适用
SQL> create or replace procedure insertdmdata_proc as begin end ;/
2 /
警告: 创建的过程带有编译错误。
SQL> show err
PROCEDURE INSERTDMDATA_PROC 出现错误:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/38 PLS-00103: 出现符号 "END"在需要下列之一时:
begin case declare exit for
goto if loop mod null pragma raise return select update while
with <an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
SQL>