Re: how to return a recordset from PL/SQL FUNCTION

Hello Sybrand,

> I have this PL/SQL function which saves a new customer into
> the Database, but it firstly checks whether there are
> customer(s) already having some exact key fields (lastname
> , zipcode, street name) to avoid this way having repeated
> customers in the DB. I do the cheking in the same
> inserting function to avoid roundtrip calls.
>
> Your unnecessary SELECT still executes a context switch (switching
> from PL/SQL to SQL and vice versa), it also generates a roundtrip.
>

When I said roundtrip I was meaning exactly network traffic, having to achieve a checking from the client-side front end whatever it is, and not a context switching which always is inside the Database.

Regards,
Giovanni Received on Fri Sep 06 2002 - 14:41:41 CDT