How can do I run the following stored procedure in SQL/PLUS? I need to define a variable for OUT_customer_information_rec, include it in the parameter list and then print it. (I can't find the answer in Feuerstein's book)
Code:create or replace procedure get_customer_info ( IN_customer_nbr IN NUMBER, OUT_customer_information_rec OUT customer_information%rowtype) IS BEGIN SELECT * INTO OUT_customer_information_rec FROM customer_information WHERE customer_nbr = IN_customer_nbr; END;
This does NOT work:
Code:variable c1 customer_inforamtion.rowtype; exec get_customer_info (123, :c1); print c1;


)
Reply With Quote
Bookmarks