PLS-00103：遇到符号“CREATE”。 [英] PLS-00103: Encountered the symbol "CREATE"

问题描述

  DECLARE  
 a NUMBER; 
 b NUMBER; 
 c NUMBER; 
 findMin VARCHAR2（ 20 ）; 
  CREATE  或 REPLACE  PROCEDURE  findMIN  AS （a  IN  NUMBER，b  IN  NUMBER，c OUT NUMBER）
  BEGIN  
a：=  23 ; 
 b：=  45 ; 
 findMin（a，b，c）; 
 dbms_output.put_line（' 最小值（23,45）：' || c） ; 
  END ; 

解决方案

第一次看你错过了程序结束时单斜杠[ / ]：

 创建 .... 
  BEGIN  
 
  END ; 
 / 

请参阅：

http://stackoverflow.com/questions/9231788/create-oracle-package-encountered-pls- 00103-encounter-the-symbol-create [ ^ ]

http://stackoverflow.com/questions/25663993/error6-1-pls-00103-encountered-the-symbol-create [ ^ ]

http://stackoverflow.com/questions/20334067/pls-00103-encount ered-the-symbol-create [ ^ ]

DECLARE
    a NUMBER;
    b NUMBER;
    c NUMBER;
    findMin VARCHAR2(20);
CREATE OR REPLACE PROCEDURE findMIN AS (a IN NUMBER,b IN NUMBER,c OUT NUMBER)
BEGIN
   a:= 23;
   b:= 45;
   findMin(a, b, c);
   dbms_output.put_line(' Minimum of (23, 45) : ' || c);
END;

解决方案

At the first look you missed single slash [/] at the end of procedure:

CREATE ....
BEGIN

END;
/

Please, see:
http://stackoverflow.com/questions/9231788/create-oracle-package-encountered-pls-00103-encountered-the-symbol-create[^]
http://stackoverflow.com/questions/25663993/error6-1-pls-00103-encountered-the-symbol-create[^]
http://stackoverflow.com/questions/20334067/pls-00103-encountered-the-symbol-create[^]

这篇关于PLS-00103：遇到符号“CREATE”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！