Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: "Execute Immediate" problem

Re: "Execute Immediate" problem

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Mon, 7 Apr 2003 13:01:50 +0200
Message-ID: <b6rlo0$p8a$1@news.mch.sbs.de>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US