Why the DBMS_SQL can't parse the command(trigger)?

From: wls <cuba_at_ms.chttl.com.tw>
Date: Tue, 14 Dec 1999 09:22:41 +0800
Message-ID: <945135091.931441@news.chttl.com.tw>

---

Why the DBMS_SQL can't parse the command?

ORA-01031:insufficient  privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 487
ORA-06512: at "SYS.DBMS_SQL", line 32


--------------------------------------------------------------

Procedure TEST
IS

    iCursorID integer;
    vCommand varchar2(4096);
    iReturned integer;
    enter varchar2(2):=chr(10);
BEGIN
vCommand:='Create or replace trigger worker.test after insert on worker.uidpwd for each
row'||enter||'declare'||enter||'begin'||enter||'null;'||enter||'end;'||enter ||'/';

    iCursorID:=DBMS_SQL.Open_Cursor;
    DBMS_SQL.Parse(iCursorID,vCommand,DBMS_SQL.native);     iReturned:=DBMS_SQL.Execute(iCursorID);     DBMS_SQL.Close_Cursor(iCursorID);
END; Received on Mon Dec 13 1999 - 19:22:41 CST