Performance concerns with a single db functions servicing all data requests

I am considering data access solution where every data request from the applications invokes a single stored function, and I am wondering if may result in resource contention.

The single generic function will accept a CLOB containing the id of the calling process and the list of arguments - all recorded as XML document. Based on this information the function will figure out what stored programs to call, will execute them, and will return all requested data in XML format (as CLOB).

The objective of this approach is to move all data access logic from the mid-tier to the database, and to simplify mid-tier development by having just a single servlet.

Can many simultaneous calls to the same PL/SQL object (disregarding any possible data contention) in any way affect performance?

Thanks
-Art Received on Tue Aug 07 2007 - 21:18:57 CDT