Forums before death by AOL, social media and spammers... "We can't have nice things"
| comp.databases.oracle | Overblown overpriced overengineered SHIT | 2,288 messages |
[ << oldest | < older | list | newer > | newest >> ]
| Message 537 of 2,288 |
| ovkrishna to All |
| Re: Difference execute immediate within |
| 16 Oct 03 12:51:06 |
From: member44474@dbforums.com Truncate is a DDL statement and to use DDL statements within your Stored Porcedure, you either need to use DBMS_DDL (or is it DBMS_SQL) package. You cannot execute them directly. That is the reason you are getting the compilation error. -- Posted via http://dbforums.com --- SoupGate-Win32 v1.05 * Origin: you cannot sedate... all the things you hate (1:229/2) |
(c) 1994, bbs@darkrealms.ca