Oracle

create or replace
PROCEDURE Billing.USP_BillingKeywordTest ( p_accountKey number, p_returncur OUT sys_refcursor ) IS
BEGIN
   open p_returncur for
   select * from billing.bill where bill.accountkey= p_accountKey;
   dbms_output.put_line('returning from procedure');
END;
Note: The Oracle stored procedure uses p_returncur as the output parameter for the return data. This is required to return the cursor content for the keyword collection.