Re: Function calls in Forms
Date: Sat, 23 Jun 2001 09:09:04 -0700
Message-ID: <tj9o6l69end2a1_at_corp.supernews.com>
"Scott Fererro" <scott_fererro_at_csgsystems.com> wrote in message
news:95aee0a3.0106221322.647dd158_at_posting.google.com...
> I have a problem in calling functions in Forms. I have a main
> procedure that gets called and a parameter that gets passed into it.
> This parameter is the name of a function that needs to be run. I
> could use an IF-THEN-ELSIF structure but I have a couple of hundred
> functions that could be called so I don't want a big IF tree. Is
> there a PL\SQL command that would take a varchar2 as a parameter to
> execute the function?
> Scott Fererro
In the function that's being called, you'll need to write dynamic SQL to take the parameter you passed in and turn it into a dynamic PL/SQL block. Look at the DBMS_SQL package to do this.
-Matt Received on Sat Jun 23 2001 - 18:09:04 CEST