Re: dynamic sql

Gabriel Adolfo Sirni <gsirni@yahoo.com> writes:
> Procedure pr_prueba(param in varchar2) is
> v_name varchar2(50);
> BEGIN
> EXECUTE IMMEDIATE ' Begin pr_out_area_code(:1,:2);
> End; ' USING param, OUT v_name;
> END;

You're asking the wrong people; this is not an Oracle mailing list.
        regards, tom lane