It worked fine for me when I granted "CREATE ANY TRIGGER" rights first.
"wls" <cuba_at_ms.chttl.com.tw> wrote in message
news:945138645.860873_at_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 Wed Dec 15 1999 - 15:25:23 CST
