jflemin
asked on
truncate table in a package/proc
What rights do I have to grant to a user to truncate a table in a package?
I have TRUNCATE TABLE table_name in a proc inside of a package. When I try to compile it, I get an error:
LINE/COL ERROR
-------- -------------------------- ---------- ---------- ---------- ---------
363/12 PLS-00103: Encountered the symbol "TABLE" when expecting one of
the following:
:= . ( @ % ;
The symbol ":= was inserted before "TABLE" to continue.
I have TRUNCATE TABLE table_name in a proc inside of a package. When I try to compile it, I get an error:
LINE/COL ERROR
-------- --------------------------
363/12 PLS-00103: Encountered the symbol "TABLE" when expecting one of
the following:
:= . ( @ % ;
The symbol ":= was inserted before "TABLE" to continue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER