I am getting the same results with both of the statements below. With my test data, the difference in speed doesn't seem to be significant. Is there an advantage of one over the other?


execute procedure GETCOMMISSIONAMT(COMPANY, PRODUCT, SALEAMT)
returning_values FULL_COMMISSION, SPLIT_COMMISSION;


select *
from GETCOMMISSIONAMT(COMPANY, PRODUCT, SALEAMT)
into FULL_COMMISSION, SPLIT_COMMISSION;