Re: Performance concerns with a single db functions servicing all data requests

artmt_at_hotmail.com wrote in
news:1186599963.471522.91020_at_d55g2000hsg.googlegroups.com:

>
> All calls to the generic function will be identical:
> SELECT fn_generic(p_xml_params) FROM dual
>
> How do bind variables come into play here?
>

>> 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).

You should be using bind variables in the "stored program" above. Received on Wed Aug 08 2007 - 21:21:46 CDT