| Re: Truncate Table problem [message #369625] |
Thu, 16 November 2000 18:10  |
Andrew
Messages: 144
Registered: March 1999
|
Senior Member |
|
|
The right approach would be to ask: What has changed from when it last worked until the problem was discovered (as you have probably done). Things like system parameters, an increase in data size. Have you restarted the server??
You could also try the 8.1.5 simplified syntax like:
DECLARE
v_sql_stmt VARCHAR2(100);
BEGIN
v_sql_stmt := 'truncate table ABC';
EXECUTE IMMEDIATE (v_sql_stmt);
EXCEPTION
WHEN OTHERS
THEN
RAISE_APPLICATION_ERROR (-20500, 'ERROR: Problem while Truncating (blah blah blah).', TRUE);
END;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
