execute privileges error

From: L. Tseng <lesliet_at_u.washington.edu>
Date: 1996/12/16
Message-ID: <594idc$d6e@nntp1.u.washington.edu>#1/1

I created the following procedure under SYSTEM but keep getting the following error

ERROR at line 1:

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 239
ORA-06512: at "SYS.DBMS_SQL", line 25
ORA-06512: at "SYSTEM.TEST_DBMSSQL", line 7
ORA-06512: at line 1

SYSTEM has been granted execute any procedure privilege but it does not help.

The procedure would only work when created under SYS schema and logging in as SYS.

What is wrong???

create or replace procedure test_dbmssql as

 cursor_name                NUMBER;
 ignore                     NUMBER;

 BEGIN
 cursor_name := DBMS_SQL.OPEN_CURSOR;
 DBMS_SQL.PARSE(cursor_name,'drop user Austin', DBMS_SQL.V7);  ignore := DBMS_SQL.EXECUTE(cursor_name);  END; Received on Mon Dec 16 1996 - 00:00:00 CST