Re: difference between a packaged procedure and a stored procedure/function

Home -> Community -> Usenet -> c.d.o.misc -> Re: difference between a packaged procedure and a stored procedure/function

From: <Dawn.Hoffmann_at_reedtech.com>
Date: Mon, 22 Nov 1999 19:55:21 GMT
Message-ID: <81c737$fb5$1@nnrp1.deja.com>

> One more question, perhaps two? I noticed that the Oracle docs say a
> function returns a value, but it does not say a procedure does not.

> Can a procedure return a value like a function,
If you use OUT or IN OUT on a parameter when declaring the PROCEDURE then it can return a value. (Of course it is not returned in the same manner as a function call.)

> and can a function have in/out parameters?
Yes

I bought this book: Oracle 8 PL/SQL Programming By Scott Urman to use as a reference and it has been very useful. You may like it too.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 22 1999 - 13:55:21 CST