Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: "Execute Immediate" problem
> 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 Received on Mon Apr 07 2003 - 06:01:50 CDT
![]() |
![]() |