Newbie SELECT question

From: Programmer <nospam_at_metros.org>
Date: Thu, 3 Jun 1999 21:47:14 -0400
Message-ID: <37572dc6_at_exchange.surfree.com>

[Quoted] [Quoted] I am new to Oracle and am used to being able to create stored procedures in SQL Server that return multiple rows. It was pretty simple; you could just create a procedure as follows:

create procedure USP_GET_STATE as
select state_cd from state_code

Then, from any application, I would call the stored procedure using execute USP_GET_STATE. How do I do this with Oracle, since it doesn't seem that multiple rows can be returned in a stored proc.

Thanks
Scott
(scott_at_metros.org)

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! [Quoted] [Quoted] ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Jun 04 1999 - 03:47:14 CEST