Network trace of Oracle stored procedure result

I did a network trace yesterday for the results coming back from an Oracle 9.2 server running a stored procedure in a package. This was called from ADO from a windows 2003 server.

the expected resultant record set is a 15 byte customer id. The network trace shows that about 100 packets with a total size of 90K was sent to satisfy this one request. The preamble before you recieve any data was a list padded out with spaces of al lthe stored procedures and their names that were stored in tha package.

can anybody explain why this is and what can be done to stop it. The reason for doing this was because of a slow down in execution times when executing this over a 34MB Wan segment.

Thanks Received on Thu Jun 16 2005 - 16:41:36 CDT