We can use Script Component to execute Oracle stored procedures with ref cursor as parameter(s)

Add the output columns to the component.

For eg: I had a oracle package Get_Employees.GetEmployees...