Return value from stored procedure ?

Hi, I have created a simple stored procedure which will return the customer name based on the customer code that passed in ... However, I do not know how to return the value from the stored procedure to a 4GL program ? Can anyone of your enlighten me please ... thanx ... The stored procedure : create procedure get_customer_name (l_customer_code char(8)) returning varchar(40) define l_customer_name varchar(40) select customer_name into l_customer_name from customer where customer_code = l_customer_code return l_customer_name end procedure