Re: Q:Sqlnet .. multiple queries in a single packet ?

In article <8s8csu$ltt$1_at_nnrp1.deja.com>,   EnderW <ender29_at_my-deja.com> wrote:
> Hi,
> My basic question is if there is a way to tell SQLNet to bundle
> queries and send them together and get the results. What happens is
> that SQLNet sends each packet "each sql" seperately. Is there a way to
> tell SQLNet to send multiple sql statements in one batch ? Thanks
>
> --
> Ender Wiggin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

There is not.
It has never been there, and it will never be there, as PL/SQL has been devised for that purpose. Also, if you want to do that outside PL/SQL, IMO, there isn't any advantage to that. Most sql statements will comprise more than one TCP/IP packet, so they are going to be fragmented anyway.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.