truncate + procedure [message #355016] |
Wed, 22 October 2008 05:07  |
gupta_vama
Messages: 8 Registered: October 2008 Location: hyderabad
|
Junior Member |
|
|
Hi,
i am using truncate in procedure is
create or replace procedure proc_aggr_calmonth_sales as
begin
truncate table aggr_calmonth_sales;
insert into aggr_calmonth_sales(promo_name,promo_subcategory,promo_category...) select ... from t1,t2,t3 where .... group by(...);
commit;
exception
when others then
dbms_output.put_line('error');
end;
/
error is
pls-00103 encounted symbol "table" when expecting one of the following
:=[@%;
|
|
|
|
|
|
Re: truncate + procedure [message #355033 is a reply to message #355021] |
Wed, 22 October 2008 05:51  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Don't put solution only hint or clue as requested in OraFAQ Forum Guide, "Responding to Posts" section:
Quote: | When responding to questions, if it is obviously a student with a homework assignment or someone else just learning, especially in the homework and newbies forums, it is usual to provide hints or clues, perhaps links to relevant portions of the documentation, or a similar example, to point them in the right direction so that they will research and experiment on their own and learn, and not provide complete solutions to problems. In cases where someone has a real-life complex work problem, or at least it may seem complex to them, it may be best to provide a complete demo and explanation.
|
|
|
|