Re: Dynamic SQL to call a function with RETURN value?

From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Tue, 28 Oct 2008 06:00:06 -0700 (PDT)
Message-ID: <a83a2f4f-00c2-4665-90c5-1fbacc3594b5@l62g2000hse.googlegroups.com>


On Oct 27, 4:24 pm, sybra..._at_hccnet.nl wrote:
> On Mon, 27 Oct 2008 03:41:00 -0700 (PDT), mwmann <mwm..._at_gmail.com>
> wrote:
>
> >I presume that Dynamic SQL is the way to go, but I have not been able
> >to get it right.
>
> Dynamic SQL is the correct method to develop an application which has
> 'DISASTER' inscribed all over it.
> Your description is very vague, and from what I get from it you seem
> to have re-invented a feature which already exists in PL/SQL, albeit
> in packages, called 'Overloading'
> You would need to present much more detail (as well as a database
> version) to find out why you have a desire to end on the electrical
> chair or to make the life of your potential customers miserable.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

>>Dynamic SQL is the correct method to develop an application which has
'DISASTER' inscribed all over it. <<

Could you point to Oracle documentation, where it lists Dynamic SQL limits?
Thx
Thomas Received on Tue Oct 28 2008 - 08:00:06 CDT

Original text of this message