code_junkie

Package creation issues using SQL Developer

Nov 13th, 2011
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. create or replace package JUMPTO is
  2. type t_locations is ref cursor;
  3.  
  4. procedure procGetLocations(locations out t_locations);
  5.  
  6. end JUMPTO;
  7.  
  8. DECLARE
  9. LOCATIONS APPLICATION.JUMPTO.t_locations;
  10. BEGIN
  11.  
  12. JUMPTO.PROCGET_LOCATIONS(
  13. LOCATIONS => LOCATIONS
  14. );
  15. -- Modify the code to output the variable
  16. -- DBMS_OUTPUT.PUT_LINE('LOCATIONS = ' || LOCATIONS);
  17. END;
  18.  
  19. ORA-06550: line 2, column 32:
  20. PLS-00302: component 'JUMPTO' must be declared
  21. ORA-06550: line 2, column 13:
  22. PL/SQL: item ignored
  23. ORA-06550: line 6, column 18:
  24. PLS-00320: the declaration of the type of this expression is incomplete or malformed
  25. ORA-06550: line 5, column 3:
  26. PL/SQL: Statement ignored
  27. ORA-06512: at line 58
  28.  
  29. create or replace package body JUMPTO is
  30.  
  31. procedure procGetLocations(locations out t_locations)
  32. is
  33. begin
  34. locations := null; -- Need code here
  35. end;
  36.  
  37. end JUMPTO;
  38.  
  39. DECLARE
  40. LOCATIONS JUMPTO.t_locations;
  41. BEGIN
  42. JUMPTO.PROCGETLOCATIONS(
  43. LOCATIONS => LOCATIONS
  44. );
  45. END;
  46.  
  47. create or replace package body JUMPTO is
  48. procedure procGetLocations(locations out t_locations) is
  49. begin
  50. locations := null; -- Your code goes here
  51. end procGetLocations;
  52. end JUMPTO;
Add Comment
Please, Sign In to add comment