I am trying to call a package and return the value returned from the package in a result set not in the dbms_output.
Code
declare
result number;
myCursor REF CURSOR;
BEGIN
result := my_package(56);
open myCursor for
select result from sys.dual;
END;
I searched and found this cursor value but I cannot seem to get it to work. This is basically the result I want:
result
------
56
This is all I want to do is to display the value as a result set.