How to run functions in Oracle using Aqua Data Studio:

DECLARE

TYPE REFCURSOR IS REF CURSOR;

RETURN_VALUE REFCURSOR;

ID VARCHAR2(2000) := 'ID';

BEGIN

RETURN_VALUE := db.PKG_ID_CHAN.function1(ID);

DBMS_OUTPUT.PUT('ID: ');

DBMS_OUTPUT.PUT_LINE(ID);

END;

GO