On Aug 8, 10:21 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> ar..._at_hotmail.com wrote innews: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.
Yes. I will be.
Those programs will be envoked dynamically, but SQL inside will use
bind variables.
Received on Thu Aug 09 2007 - 13:22:31 CDT
