Home » Developer & Programmer » Forms » Error While Compling Package Body
Error While Compling Package Body [message #474201] Fri, 03 September 2010 08:44 Go to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

Hi Friend,
help me...while compling this package body, i get error

error 102 at line 21 column 11
encounterd symbol "Group" when expecting one of following

begin function package pragma procedure subtype type use form cursor


please help to correct code...solve thsi error...i attached my code here
  • Attachment: error.txt
    (Size: 2.37KB, Downloaded 1048 times)
Re: Error While Compling Package Body [message #474211 is a reply to message #474201] Fri, 03 September 2010 09:55 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
     cursor c2 is 
          select alt_cd code1,
                 sum(alt_amt) amount1
          from   acc_loc1_tab
          where alt_authdt between :BLOCK15.FROMDATE and :BLOCK15.TODATE
               and alt_loc = :BLOCK15.LOCATION ;  
          GROUP BY ALT_CD;  

get rid of first semi-colon
Re: Error While Compling Package Body [message #474215 is a reply to message #474211] Fri, 03 September 2010 10:32 Go to previous messageGo to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

Thanks You....I m so silly...

But Logic is ok ???
Re: Error While Compling Package Body [message #474218 is a reply to message #474215] Fri, 03 September 2010 10:42 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
this is unecessary:
EXIT WHEN c1%NOTFOUND;

FOR LOOPs do that automatically.

Same for this:
IF c1%ISOPEN THEN
  CLOSE c1;
END IF;


And the equivalents for the other cursor.
Re: Error While Compling Package Body [message #474223 is a reply to message #474218] Fri, 03 September 2010 11:36 Go to previous messageGo to next message
swapnil_naik
Messages: 269
Registered: December 2009
Location: Mumbai
Senior Member

ThanKS you....i will comment it....just i want to ask
My task is
Convert report in excel format ...
Grouping by Gl_code...means for each gl_cd ,what is amount....

Likewise attached format...


I hope U can help solve my task..Please Just my code...is it working for that task...

Thanks in advance...
  • Attachment: Sample.csv
    (Size: 0.34KB, Downloaded 975 times)
Re: Error While Compling Package Body [message #474225 is a reply to message #474223] Fri, 03 September 2010 12:18 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
How would I know if it's working?
I can spot obvious problems but that's not the same thing.
Try it and fix it yourself if necessary.
If you're stuck on a specific issue feel free to ask.
Previous Topic: hiding url in the run time
Next Topic: forms 10g reports
Goto Forum:
  


Current Time: Thu Sep 19 12:59:00 CDT 2024