Oracle 返回游标 PLS-00103: 出现符号 "CREATE"

转载自：http://bbs.csdn.net/topics/270072548

在创建如下package时：

create or replace package p_view_param  is  
   function set_param(num number) return number;  
   function get_param  return number;  
   
   end p_view_param;  
    
   create or replace package body p_view_param is  
       paramValue number;  
       function set_param(num number) return number is  
       begin  
         paramValue:=num;  
         return num;  
        end;   
        
       function get_param return number is  
       begin  
         return paramValue;  
       end;  
        
   end p_view_param;   

pl/sql developer总会报以上异常，在度娘的帮助下找到了解决方法。

oracle中，在存储过程返回数据集；返回游标的时候报错：PLS-00103: 出现符号 "CREATE"；这是什么问题呢？SQL如下：

CREATE OR REPLACE PACKAGE  TESTPACKAGE AS
TYPE TEST_CURSOR IS REF CURSOR;
END TESTPACKAGE;

CREATE OR REPLACE PROCEDURE TEST1 ( TEST_CUSROR OUT TESTPACKAGE.TEST_CURSOR) AS
BEGIN
OPEN TEST_CURSOR FOR SELECT * FROM test_table;
END TEST1;

SQL> CREATE OR REPLACE PACKAGE TESTPACKAGE IS
  2  TYPE TEST_CURSOR IS REF CURSOR;
  3  PROCEDURE TEST1 (V_CURSOR OUT TEST_CURSOR);
  4  END TESTPACKAGE;
  5  /
 
Package created
 
SQL> CREATE OR REPLACE PACKAGE BODY TESTPACKAGE IS
  2  PROCEDURE TEST1 (V_CURSOR OUT TEST_CURSOR) IS
  3  BEGIN
  4      OPEN V_CURSOR FOR SELECT * FROM bi_request_sim_card;
  5  END TEST1;
  6  end TESTPACKAGE;
  7  /
 
Package body created