So I've never worked with stored procedures and have not a whole lot of DB experience in general and I've been assigned a task that requires I create a package and I'm stuck.

所以我从来没有使用存储过程,并且一般没有大量的数据库经验,我被分配了一个任务,需要我创建一个包,我被卡住了。

Using SQL Developer, I'm trying to create a package called JUMPTO with this code...

使用SQL Developer,我正在尝试使用此代码创建一个名为JUMPTO的包...

create or replace package JUMPTO is
  type t_locations is ref cursor;

  procedure procGetLocations(locations out t_locations);

end JUMPTO;

When I run it, it spits out this PL/SQL code block...

当我运行它时,它会吐出这个PL / SQL代码块...

DECLARE
  LOCATIONS APPLICATION.JUMPTO.t_locations;
BEGIN

  JUMPTO.PROCGET_LOCATIONS(
    LOCATIONS => LOCATIONS
  );
  -- Modify the code to output the variable
  -- DBMS_OUTPUT.PUT_LINE('LOCATIONS = ' || LOCATIONS);
END;

A tutorial I found said to take out the comment for that second line there. I've tried with and without the comment.

我发现的一个教程说要在那里拿出第二行的评论。我曾尝试过无论是否有评论。

When I hit "ok" I get the error...

当我点击“确定”时,我收到错误...

ORA-06550: line 2, column 32:
PLS-00302: component 'JUMPTO' must be declared
ORA-06550: line 2, column 13:
PL/SQL: item ignored
ORA-06550: line 6, column 18:
PLS-00320: the declaration of the type of this expression is incomplete or malformed
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored
ORA-06512: at line 58

I really don't have any idea what's going on, this is all completely new territory for me. I tried creating a body that just selected some stuff from the database but nothing is working the way it seems like it should in my head. Can anyone give me any insight into this?

我真的不知道发生了什么,这对我来说都是一个全新的领域。我尝试创建一个刚刚从数据库中选择一些东西的主体,但没有任何东西像我脑子里想象的那样工作。任何人都可以给我任何洞察力吗?

2 个解决方案

create or replace package body JUMPTO is

  procedure procGetLocations(locations out t_locations)
  is
  begin
    locations := null; -- Need code here
  end;

end JUMPTO;

 DECLARE
     LOCATIONS JUMPTO.t_locations;
   BEGIN
     JUMPTO.PROCGETLOCATIONS(
       LOCATIONS => LOCATIONS
     );
   END;

create or replace package body JUMPTO is  
procedure procGetLocations(locations out t_locations) is  
begin    
locations := null; -- Your code goes here
end procGetLocations;
end JUMPTO;