Re: Why do I get this sqlplus error?

If you're using Oracle8i Guang, this kind of thing is a bit easier. You can replace all those DBMS_SQL calls with the "EXECUTE IMMEDIATE" statement, so :

...

  cursor_id integer;
 begin
  cursor_id := dbms_sql.open_cursor;
  dbms_sql.parse(cursor_id, 'DROP '||obj_type_in||' '||obj_name_in,  dbms_sql.NATIVE);
  dbms_sql.close_cursor(cursor_id);
 exception
...

becomes :

...

 begin
  execute immediate 'DROP '||obj_type_in||' '||obj_name_in ;  exception
...

Regards
Steve Blomeley Received on Wed Jun 07 2000 - 00:00:00 CDT