How to fix these bugs!!!

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

Hello all,

I am now doing a project and in which I need to use Oracle to provide a service for the users to search a company from a list of companies. In order to do this, firstly, I want to allow the users to search this by choosing the first character of a company name, e.g. "A" But there are bugs in my oracle program and I don't know how to fix them. Could you give some suggestions to me?

Thanks!

Connie

---

The following is the message after compile:

LINE/COL ERROR

• ----------------------------------------------------------------- 14/2 PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

14/2 PL/SQL: Statement ignored

---

The following is my with-bug program:

• interface create or replace package newchi is

procedure fyp_scna;
end ;
/

show errors

create or replace package body newchi is

procedure fyp_scna is

    cursor all_object is select * from firms f ,Co_bg c ,FileUrl u where f.co_name='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.co_url,each_object.co_name));
	htp.tableData(each_object.year);
	htp.tableRowOpen;

 end loop;
 htp.tableClose;
 end; -- end of fyp_scna
 end newchi;
/
Received on Tue Mar 04 1997 - 00:00:00 CST