Re: Return table set in stored procedure

From: Romeo Olympia <rolympia_at_hotmail.com>
Date: 24 Nov 2004 18:06:37 -0800
Message-ID: <42fc55dc.0411241806.7a216ad0@posting.google.com>

"Nils Magnus Englund" <nils.magnus.englund_at_orkfin.no> wrote in message news:<WlWod.553$72.180214272_at_news.telia.no>...
> Hi!
>
> I'm quite new to Oracle, coming from a background of dabbling a bit with
> Microsoft SQL Server (although I'm not particularly experienced with SQL
> Server either).
>
> What is Oracles equivalent of a stored procedure with parameters, returning
> a result set?
>
> e.g. in MSSQL I could do this:
>
> CREATE PROCEDURE SelectMoreThan (@Value INT) AS
> BEGIN
> SELECT * FROM table WHERE column > @Value
> END
>
> And running "EXEC SelectMoreThan 5" would return to me all rows with a
> Column value exceeding 5. How would I accomplish the same in Oracle?
>
>
>
> Thanks!
>
>
>
> Sincerely,
> Nils Magnus Englund

One more important resource is AskTom. Here's regarding your post:

http://asktom.oracle.com/pls/ask/f?p=4950:8:5856256725244291078::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:625023646727,

Cheers. Received on Wed Nov 24 2004 - 20:06:37 CST