SEO

#1 (**permalink**) 02-24-2008, 09:09 AM

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

#2 (**permalink**) 02-24-2008, 09:11 AM

Use a ref cursor to get this to work in oracle.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Return table set in stored procedure