truncate problems in PL/SQL

I am writing a PL/SQL routine that needs to truncate a summary table before starting, the code goes something like this:

DECLARE
  CampaignVar varchar2(80);
BEGIN
  truncate table edge_numbers;
  select Distinct(Campaign_ID)
  into CampaignVar
  etc etc etc.....

With the truncate I get error PLS-00103 from the parser, I want to trunc it on the way in and on the way out of the routine. As soon as I pull out the truncate everything works like a charm, can someone say ARRGGHH!! :) Any ideas??

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 22:15:45 CDT