Re: "Execute Immediate" problem

Originally posted by Jeremy
> In article , stephan.bressler_at_siemens.com
> says...
> > > execute immediate
> > > 'begin
> > > zp(p_web_site_id => :l_web_site_id, p_url => :l_url);
> > > end;'
> > > using l_web_site_id, l_url;
> > > end;
> > Hi
> > just a guess (if your variables are input only):
> > zp(p_web_site_id => ' || l_web_site_id || ', p_url => '|| l_url
> ||');
> >
> > Stephan
> >
> >
> >
>
>
> Thanks Stephan, but the l_url variable is an IN OUT which is what I am
> having trouble with.
>
> --
>
> jeremy

The default mode for USING clause in "IN", so you must specify "IN OUT":

execute immediate
'begin
zp(p_web_site_id => :l_web_site_id, p_url => :l_url); end;'
using l_web_site_id, IN OUT l_url;

--
Posted via http://dbforums.com