"Execute Immediate" problem

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Mon, 7 Apr 2003 11:34:38 +0100
Message-ID: <MPG.18fb649be73a77129896ec@news.cis.dfn.de>

Hi - trying to execute a procedure using 'execute immediate' syntax. The target procedure is defined thus:

create or replace procedure

zp          (p_web_site_id	in	number,
             p_url          in out  varchar2)

is
....

And the calling proc is this:

declare
  l_web_site_id number := 61;
  l_url varchar2(240) := 'http://www.xxx.com'; begin
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;

When I execute I get the following:

11:09:20 SQL> @z
declare
*
ERROR at line 1:
ORA-06536: IN bind variable bound to an OUT positio ORA-06512: at line 22

How do I have to code my 'execute immediate' in order to be able to have an in/out variable passed?

-- 

jeremy

Received on Mon Apr 07 2003 - 05:34:38 CDT