create or replace procedure proc_check
select * from tablename;
I 'm trying to compile this procedure in oracle 9i, but oracle is giving me the error as into clause expected.
If i write query using into clause procedure gets compiled successfully.
Also if is use the cursor then also procedure gets compiled successfully.
Is it possible to return a result set through procedure in oracle ???
since into clause will store only one value and cursor will have only one record......
please suggest me solution so that i can return a resultset (i.e table as a output) in Oracle 9i