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: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Mon, 7 Apr 2003 12:01:52 +0100
Message-ID: <MPG.18fb6af0426dd0fa9896ed@news.cis.dfn.de>


In article <b6rlo0$p8a$1_at_news.mch.sbs.de>, 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
Received on Mon Apr 07 2003 - 06:01:52 CDT

Original text of this message

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