Stored Procedure Question

I am just starting to learn Oracle so be gentle. Here is my question:

I am trying to create a stored procedure as follows:

CREATE PROCEDURE SP_BOMINQ (ASSY CHAR ) AS BEGIN
SELECT Assembly,Component,Usage,Revision,UOM,Datein,Dateout,ChangId,Line FROM BOM
WHERE Assembly = ASSY
Order By Line,Datein;
END; This will not compile and gives me the following error:

PLS-00428: an INTO clause is expected in this SELECT statement.

I cannot see why I would need an INTO clause in a simple Select statement. Can someone advise?

• Ian S.