Re: Is this possible with "execute immediate"

From: Jeremy <jeremy0505_at_gmail.com>
Date: Wed, 26 Apr 2006 16:38:20 +0100
Message-ID: <MPG.1eb9a3c8e2cbd58e98a19b@news.individual.net>

In article <MPG.1eb9a045dc7647c498a19a_at_news.individual.net>, Jeremy says...
> In article <H4-dnUcTFd29FtLZRVn-sg_at_comcast.com>, Mark C. Stock says...
> >
> >
> > it may be doable just in the package without creating a persistent type in
> > the database ... worth a try
> >
>
> Any examples of this (new area for me) - or keywords to search oracle
> doc on?
>

Follow-up on own post time:

This compiled OK:

create type mytype as table of varchar2(2000) /

create or replace procedure p
is
  l_name mytype;
begin
  begin
    execute immediate

      'begin myproc(p_web_site_id=>3,p_name=>:b1); end;'
      using in l_name;

  exception
    when others then
      dbms_output.put_line(sqlerrm(sqlcode));   end;
end p;
/
sho err

So changing the definition of l_name to be of type "mytype" instead of wd_util.array

Now to see if the rest of it behaves as hoped ;)

thanks

-- 

jeremy

Received on Wed Apr 26 2006 - 10:38:20 CDT