Re: Views based on function returning table

Hmmm, back to school then. Thanks for the corrections.

 ;

Regards,

Gabriel

 

On 3/6/08, Gints Plivna < gints.plivnagmail.com">gints.plivnagmail.com> wrote:

2008/3/6, Gabriel Tanase < gabtanasegmail.com">gabtanasegmail.com>:
> I am saying this based on my understanding is that nowadays the SQL and
> PL/SQL engines are co-mingled (for want of a better word) and there are no
> costly context switches (process + memory space) anymore when SQL calls
> PL/SQL and PL/SQL passes result sets back.

Context switches do exist. And overhead as well. There are however
some explicit means to overcome that as well as implicit conversion
for very limited constructs.