Is it possitble to display data on screen using a procedure.

I have a select statement which is parameterised.
I want to put this in a PL/SQL procedure.Which is fine to do have an IN paramater.

Is there any way to print the data on the screen after i execute the procedure.


Ex: SQL>execute proc_select(abc);


123 abc 8484 ndhjd


is there any way to do this.

plz help.