From: John Verbil Subject: Re: How to prevent deletes when DELETE ANY TABLE granted? Date: 1996/12/12 Message-ID: <32B05664.165A@netmail.mnet.uswest.com>#1/1 references: <199612121852.NAA04398@arl-gw-6.compuserve.com> to: Todd Verstraten content-type: text/plain; charset=us-ascii organization: U S WEST Information Technologies - IAD mime-version: 1.0 newsgroups: comp.databases.oracle.server x-mailer: Mozilla 3.0 (X11; I; HP-UX B.10.10 9000/712) Todd Verstraten wrote: > > Does TRUNCATE not work in DBMS_SQL? I have tried many other DDL statements > that have worked bu not truncate. It doesn't. I've tried it in the past and, just to be sure, tried it again today. You'll get the following message when you try to compile your procedure: truncate table replica; * ERROR at line 2: ORA-06550: line 2, column 10: PLS-00103: Encountered the symbol "TABLE" when expecting one of the following: := . ( @ % ; The symbol ":= was inserted before "TABLE" to continue. -- John Verbil U S WEST Communications Information Technologies jverbil@uswest.com (303) 896-0916