SQL & PL/SQL

Hi,

I have to write a member procedure to print out all current offers stored in a offer table.

The code i've wrote so far is below:

create or replace type body offer_typA as
member procedure Display_current_offers is
Description Varchar2(30);
begin
SELECT Desc INTO Description
FROM offer_objtabA
WHERE Expiry_date >= SYSDate;
dbms.output.put_line('Current Offers: ' || Description);
end Display_current_offers;
end;
/
show errors;

I'm not sure whether this will work, it it possiblr to print out multiple values?

Cheers