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.