Why the DBMS_SQL can't parse the command(trigger)?
From: wls <cuba_at_ms.chttl.com.tw>
Date: Tue, 14 Dec 1999 10:22:01 +0800
Message-ID: <945138649.400490_at_news.chttl.com.tw>
Why the DBMS_SQL can't parse the command?
Date: Tue, 14 Dec 1999 10:22:01 +0800
Message-ID: <945138649.400490_at_news.chttl.com.tw>
Why the DBMS_SQL can't parse the command?
[Quoted] 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 Tue Dec 14 1999 - 03:22:01 CET