Re: EXECUTE IMMEDIATE

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 2000/05/29
Message-ID: <01bfc971$3b6622e0$2c289a0a@apollo>#1/1

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 Received on Mon May 29 2000 - 00:00:00 CDT