execute_immediate does not work any more!!!

From: Fengqing Zhou <zhouf_at_rintintin.Colorado.EDU>
Date: 10 Aug 1998 19:51:02 GMT
Message-ID: <6qniv6$ghg@peabody.colorado.edu>

Hi!

The following used to work, but not for Oracle 7.3.4 and 8.0.3. Anyone (Thomas)

Procedure created.  

sql> l
  1 create or replace procedure execute_immediate( stmt in varchar2 )   2 as

  3      exec_cursor     integer default dbms_sql.open_cursor;
  4      rows_processed  number  default 0;
  5  begin
  6      dbms_sql.parse(exec_cursor, stmt, dbms_sql.native );
  7      --rows_processed := dbms_sql.execute(exec_cursor);
  8      --dbms_sql.close_cursor( exec_cursor );

  9* end;
sql> exec execute_immediate('drop table which_does_not_exist'); begin execute_immediate('drop table which_does_not_exist'); end;  

*
ERROR at line 1:

ORA-00911: invalid character
ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "SYS.EXECUTE_IMMEDIATE", line 6
ORA-06512: at line 1

Received on Mon Aug 10 1998 - 14:51:02 CDT