Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
but I can't get it to return records like I can with SQL Server. The closest I can get is using a SYS_REFCURSOR to return a cursor I can loop through and see in the script output.
BEGIN VALIDATION_TOOLS.SP_SETTLED_REBATES_TRIM_FIELDS('14-Aug-14'); COMMIT; END;