Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace package JUMPTO is
- type t_locations is ref cursor;
- procedure procGetLocations(locations out t_locations);
- end JUMPTO;
- 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;
- 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
- 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;
Add Comment
Please, Sign In to add comment