Bugs again! Thanks!

From: Wingyu <im_hwyaa_at_stu.ust.hk>
Date: 1997/03/09
Message-ID: <Pine.SUN.3.95L.970309152937.1605A-100000@uststu5.ust.hk>#1/1

Hello all,

I found bugs again... how to fix them this time....

The message is .....

---

LINE/COL ERROR

-------- -----------------------------------------------------------------
19/4     PL/SQL: Statement ignored
19/41    PLS-00302: component 'FILE_URL' must be declared
20/2     PL/SQL: Statement ignored

20/28 PLS-00302: component 'YEAR' must be declared

---

and the program is .....

---

• interface create or replace package newchi2 is

procedure fyp_scna;
end ;
/
show errors

create or replace package body newchi2 is

procedure fyp_scna is

    cursor all_object is select f.co_id f_co_id,f.co_name f_co_name,c.co_id c_c$
u.year u_year,u.file_url u_file_url from firms f,FileUrl u,Co_bg c where f.co_name like 'A%' and f.co_id=c.co_id and f.co_id=u.co_id order by f_co_name;

 begin

 htp.bodyopen('http://imsu11.ust.hk:9000/ar/img/t2.gif');
 htp.p('The Companies with "A" as the first character:');
 htp.nl;
 htp.tableOpen('yes');
 htp.tableRowOpen;
 htp.tableData(htf.strong('Company Name'));
 htp.tableData(htf.strong('Year'));
 htp.tableRowClose;

 for each_object in all_object
 loop

        htp.tableRowOpen;
	htp.tableData(htf.anchor(each_object.file_url,each_object.co_name));
        htp.tableData(each_object.year);
        htp.tableRowOpen;

 end loop;
 htp.tableClose;
 end; -- end of fyp_scna
 end newchi2;
/

---

Thanks!

Connie

                                                            ..::''''::..
                                                          .;''        ``;.
       Name => Ho Wing Yu, Wingyu                        ::    ::  ::    ::
 Department => Information and Systems Management, Yr 3 ::     ::  ::     :: 
      Email => im_hwyaa_at_stu.ust.hk                      :: .:' ::  :: `:. ::
               wingyu_at_susis.ust.hk                      ::  :          :  ::
        URL => http://home.ust.hk/~im_hwyaa              :: `:.      .:' ::
               				                  `;..``::::''..;'
                                                            ``::,,,,::''
 

   --`--,{@ --`--,{@ --`--,{@ --`--,{@ @}`--,-- @}`--,-- @}`--,-- @}`--,-- Received on Sun Mar 09 1997 - 00:00:00 CST