Oracle 10g I have a stored procedure that I invoke from a sql*plus session connected as schema ca50633. It executes the following command which fails with an error message about insufficient privileges.
COMMAND := 'TRUNCATE TABLE RT_TEST.STATIC_DATA';
EXECUTE IMMEDIATE COMMAND;
I have granted ca50633 all privileges on the rt_test.static_data table from the rt_test schema and can truncate the table interactively from sql*plus.
What am I missing?