usage of rowtype in parameter list for stored proc

[TimHall]

Do it as part of a PL/SQL block then output the results using DBMS_OUPUT:

SET SERVEROUTPUT ON
DECLARE
v_c1 customer_inforamtion%rowtype
BEGIN
get_customer_info (123, v_c1);

-- Output the data
DBMS_OUTPUT.PUT_LINE('v_c1.col1: ' || v_c1.col1);
DBMS_OUTPUT.PUT_LINE('v_c1.col2: ' || v_c1.col2);
-- etc.
END;
/

Obviously, modify the column names and the numbers of columns accordingly.

Cheers