如何执行包&它的程序 [英] How to execute package & its procedure

问题描述

亲爱的所有



我在oracle写了一个商店程序如下

  CREATE  或 REPLACE PACKAGE ESUPPORT.DEPARTMENT  AS  
  TYPE  CURSOR_TYPE  IS  REF  CURSOR ; 
  PROCEDURE  GET_EMPS（O_RESULT_SET OUT CURSOR_TYPE）; 
  END ; 
 / 
  CREATE  或 REPLACE PACKAGE BODY ESUPPORT.DEPARTMENT  AS  
  PROCEDURE  GET_EMPS（O_RESULT_SET OUT CURSOR_TYPE）
  AS  
  BEGIN  
  OPEN  O_RESULT_SET  FOR  
  SELECT  *  FROM  ESUPPORTV_HR_EMP_DATA_FINAL; 
  END ; 
  END ; 
 / 

当我试图执行它时，在toad中为oracle

显示如下错误：

 ORA-06550：第1行第11列：
 PLS -00103：遇到以下某种情况时遇到符号DEPARTMENT：
 
：=。 （@％; 
符号：=代替DEPARTMENT继续。

任何人都可以帮助我??



提前谢谢。



SHOUTING删除 - OriginalGriff [/ edit]

解决方案

schemaname不应该是包定义的一部分。所以如果 ESUPPORT 是schemaname它应该省略。

这是不对的。

在其他用户的模式中创建包时，schemaname是必需的

 创建 或更换包裹部... 

Dear all

I have written one store procedure in oracle as follows

CREATE OR REPLACE PACKAGE ESUPPORT.DEPARTMENT AS
           TYPE  CURSOR_TYPE IS REF CURSOR;
          PROCEDURE GET_EMPS (O_RESULT_SET OUT CURSOR_TYPE);
        END;
/
CREATE OR REPLACE PACKAGE BODY ESUPPORT.DEPARTMENT AS
PROCEDURE GET_EMPS (O_RESULT_SET OUT CURSOR_TYPE)
AS
          BEGIN
             OPEN O_RESULT_SET FOR
             SELECT * FROM ESUPPORTV_HR_EMP_DATA_FINAL ;
           END;
END;
/

While I am trying to execute it, in toad for oracle
It shows below error:

ORA-06550: line 1, column 11:
PLS-00103: Encountered the symbol "DEPARTMENT" when expecting one of the following:

   := . ( @ % ;
The symbol ":=" was substituted for "DEPARTMENT" to continue.

Can anybody help me??

Thank you in advance.

[edit]SHOUTING removed - OriginalGriff[/edit]

解决方案

The schemaname should not be a part of the package definition. So if ESUPPORT is the schemaname it should be omitted.
That was not correct.
The schemaname is necessary when creating a package in the schema of an other user

CREATE OR REPLACE PACKAGE DEPARTMENT ...

这篇关于如何执行包&它的程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！