Re: EXECUTE IMMEDIATE

It is available in 8.0 but somewhere else.

desc dbms_utility

...
procedure exec_ddl_statement(parse_string in varchar2);

• Will execute the DDL statement in parse_string
• parse_string
• DDL statement to be executed end;

--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"Peter Laursen" < ptl_at_edbgruppen.dk> wrote in message
news:01bfc971$3b6622e0$2c289a0a_at_apollo...


> AM <a.metzger_at_nmg.fr> skrev i artiklen <39326854.9A3B670A_at_nmg.fr>...

> > Hi,

> >

> > I have Oracle 8.0.6. I want to execute a script written for Oracle

> > 8.1.5. In the script I have a "EXECUTE IMMEDIATE" command. But under

> > Oracle 8.0.6, the "EXECUTE IMMEDIATE" doesn't seem to work properly ?

> >

> EXECUTE IMMEDIATE is version 8.1.x and up. In 8.0 you will have to use

> dbms_sql.

> You could write your own procedure like(untested!):

> PROCEDURE execute_immediate_806 (stmt varchar2) as

>     cid integer;

> BEGIN

>     cid := dbms_sql.open_cursor;

>     dbms_sql.parse(cid, stmt, dbms_sql.native);

>     dbms_sql.close;

> EXCEPTION

>     when others then

>         dbms_sql.close;

>         raise;

> END;

>


> /Peter Laursen

>