How do I execute a package in SQL Developer? Here is my package body. I am trying to see the results of the cursor which I am assumming is going to have the rows returned in it. I am new to Oracle and so I am having a hard time with the syntax and what it is looking for.
create or replace package custom_pkg
as
TYPE t_cursor IS REF CURSOR;
procedure usp_customdisplay_sel (p_cursor out t_cursor);
end;
create or replace package body custom_pkg
as
procedure usp_CustomDisplay_Sel (p_cursor out t_cursor)
as
begin
open p_cursor for select * from gp2.PM_REPORTS;
end usp_customdisplay_sel;
end;
I want to see the resuls for the select statement. Isn't there an easier way to do this with procedures?
Thanks,
Greg