Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP! SP compiles but won't run
In article <689741.0203220811.65f3d595_at_posting.google.com>, tomg_at_asdsoftware.com
says...
>
>Okay, maybe I need to ask the question differently. Can anyone
>provide me with a simple example of an Oracle stored procedure that
>accepts a single numeric input and returns a single numeric output?
>It doesn't have to do a whole lot or be very practical or solve any
>problem other than returing a number.
>
>I would appreciate any help in this regard. Thanks!
>
>Cheers,
>
>Tom Galczynski
create procedure p ( x in number, y out number )
as
begin
y := x+5;
end;
or
create function f ( x in number ) return number
as
begin
return x+5;
end;
-- Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Fri Mar 22 2002 - 11:28:28 CST