Re: Newbie SELECT question

Of course you can do this in oracle.
You want to return a thing called a PL/SQL table from your function. Read about pl/sql tables in Feuerstein/s PL/SQL book.

Paul Dorsey
Dulcian, Inc.
www.dulcian.com
212 595 7223
Programmer wrote in message <37572dc6_at_exchange.surfree.com>...
>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!
>------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==----- Received on Sat Jun 05 1999 - 19:07:34 CEST