troubleshooting Question

How to Return a resultset in Oracle 9i without using cursor

Avatar of techprocess
techprocess asked on
Oracle Database
5 Comments2 Solutions518 ViewsLast Modified:
create or replace procedure proc_check
as
begin
select * from tablename;
end;

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

Thanks
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros