On Fri, Jul 26, 2013 at 12:26 PM, Alan J Davies <
Alan.Davies@...> wrote:

> **
>
>
> Thanks Mark, it appears that what I want to do is not possible. i.e.
> have the table name as a replaceable parameter. Using your example I
> would still have 3 separate statements (as now) but in a different
> format in the SP.
> What I really would like to be able to do is (paraphrase):
> declare table_to_use varchar(20);
> if my_input_parameter='T' then table_to_use='q_tool'
> else if my_input_parameter='G' then table_to_use='q_gauge'
> else if my_input_parameter='P' then table_to_use='q_ppap'
> end;
> and then this code only once in the SP.
>
> s = 'update :table_to_use set tgp_no = :tgp_no, del_date = :del_date
> where pjs_no = :pjs_no'
> EXECUTE STATEMENT (s) (tgp_no := tgp_no, del_date := del_date, pjs_no
> := pjs_no);
>
> Regards
>
> Alan
>

Your "s" is just a string. You don't have to use parameters you can
concatenate it like this:

s = 'update ' || table_to_use || ' set.....';

HTH,
Markus


[Non-text portions of this message have been removed]