Re: dbms_sql

From: Gary SMITH <Gary.Smith_at_cern.ch>
Date: 1997/12/04
Message-ID: <34867419.E51FDE0B@cern.ch>#1/1

Eleanor Shavell wrote:

> BUT, I don't know the name of the procedure , so I want to construct the
> block
> to be something like:
> 'BEGIN
> :myproc (:ls_prop,:ls_res);
> END;';
>
> I can't get this to work.
> Any ideas?
>
> Thanks a lot,
> Eleanor Shavell
> 'BEGIN
Just construct the string with the procedure name. Do not use  a bind variable.

my_proc VARCHAR(20);
parse_str VARCHAR(100);
BEGIN
    my_proc := 'do_test';
    parrse_str := 'BEGIN '||

                            my_proc||'(:ls_prop, :ls_res); '||
                        'END;';

    DBMS_SQL.PARSE(my_cur, parse_str, DBMS_SQL.V7);

    ETC....
END; Regards

--
*************************
Gary Smith
CERN, Geneva, Switzerland
Email: Gary.Smith_at_cern.ch
Tel:   +41 22 7678944
*************************

Received on Thu Dec 04 1997 - 00:00:00 CST