CREATE OR REPLACE PACKAGE curspkg_join AS
TYPE t_cursor IS REF CURSOR ;
Procedure open_join_cursor1 (io_cursor OUT t_cursor);
END curspkg_join;
CREATE OR REPLACE PACKAGE BODY curspkg_join AS
Procedure open_join_cursor1 ( io_cursor OUT t_cursor)
IS
--v_cursor t_cursor;
BEGIN
OPEN io_cursor FOR
SELECT * from Departments;
--io_cursor := v_cursor;
END open_join_cursor1;
END curspkg_join;
TYPE t_cursor IS REF CURSOR ;
Procedure open_join_cursor1 (io_cursor OUT t_cursor);
END curspkg_join;
CREATE OR REPLACE PACKAGE BODY curspkg_join AS
Procedure open_join_cursor1 ( io_cursor OUT t_cursor)
IS
--v_cursor t_cursor;
BEGIN
OPEN io_cursor FOR
SELECT * from Departments;
--io_cursor := v_cursor;
END open_join_cursor1;
END curspkg_join;
Procedure open_join_cursor1 ( io_cursor OUT t_cursor)
IS
BEGIN
OPEN io_cursor FOR 'SELECT * from Departments';
END open_join_cursor1;
END curspkg_join;