And I prefer just the other way around.

I only miss a "returning" clause to get auto-generated values back in
some INSERT statement.
=:o)

What I really miss is being able to return result sets ( = a set of
rows = the result of some SELECT) from inside a Stored Proc.

This is one of the few things I miss from M$ SQLServer!
=:o/


Have fun,
Paulo Gaspar

http://www.krankikom.de
http://www.ruhronline.de

> -----Original Message-----
> From: Nando Dessena [mailto:nandod@...]
> Sent: Wednesday, November 21, 2001 7:32 PM
>
>
> Jason,
>
> > What I would prefer to see is someone make a little utility which is
> > external to the engine that people, according to their own options and
> > requirements, would use to manage such things.
>
> I strongly believe that any efficient implementation of a "returning"
> clause should be at the engine level. So should system triggers to
> auto-generate keys, while I don't feel an urgent need for the latter and
> have dreamt about the former since the first time I used Oracle.
> Ciao
> --
> ____
> _/\/ando