Can in any way i wirte a procedure which will return oall the records from emp table

i want to use this procedure to be called from the web

make note that i want to write procedure returning rows