SQL & PL/SQL

How to execute a procedure returning ref cursor in toad?

example

CREATE OR REPLACE PACKAGE REF_CURSOR_TEST IS

TYPE T_ACCOUNTS_CURSOR IS REF CURSOR;

PROCEDURE GET_ACCOUNTS_PROCEDURE (P_ACCOUNTS OUT T_ACCOUNTS_CURSOR);

END REF_CURSOR_TEST;
/

CREATE OR REPLACE PACKAGE BODY REF_CURSOR_TEST IS

PROCEDURE GET_ACCOUNTS_PROCEDURE (
P_ACCOUNTS OUT T_ACCOUNTS_CURSOR

) AS
BEGIN
OPEN P_ACCOUNTS FOR
SELECT
Account_ID as Id,
Account_FirstName as FirstName,
Account_LastName as LastName,
Account_Email as EmailAddress

FROM Accounts
ORDER BY Account_ID;
END GET_ACCOUNTS_PROCEDURE;

END REF_CURSOR_TEST;

/


Here procedure returning ref cursor. How to debug and run this procedure in Toad.