Re: Functions

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 22 Feb 2009 12:16:54 -0700
Message-ID: <49a1b2b6_at_news.victoria.tc.ca>

gym dot scuba dot kennedy at gmail (kennedyii_at_verizon.net) wrote:

: I think the piece that he is missing is that sql statements are executed by
: the server not by the pl/sql engine. So the function is private to the
: pl/sql engine and the sql processor cannot see it. So it is a subtle
: difference that does not occur in most programming languages.
: Jim

Yes, that is certainly the underlying reason, though unless the package is part of something like an fmb file, then the pl/sql engine is itself running on the same server as the sql. Received on Sun Feb 22 2009 - 13:16:54 CST