SQL & PL/SQL

Hi

I am creating this stored proc

SQL> CREATE OR REPLACE PROCEDURE TEST0312 AS
2
3
4 CURSOR c_evnt1 IS
5 SELECT ev.poid_db as "poid_db1",
6 ev.poid_id0 as "poid_id01",
7 ev.poid_type as "poid_type1",
8 Ev.poid_rev as "poid_rev1",
9 svc.poid_id0 as "poid_id01"
10 FROM pl_evnt_sirius_sponsor_esn_t spon,
11 pl_event_t ev,
12 pl_service_t svc
13 WHERE svc.login = spon.esn
14 And svc.poid_type = '/service/Sirius/esn'
15 And spon.obj_id0 = ev.poid_id0
16 And (ev.poid_db,
17 ev.poid_id0,
18 ev.poid_type,
19 ev.poid_rev)
20 NOT IN (select first_executed_req_db,
21 first_executed_req_id0,
22 first_executed_req_type,
23 first_executed_req_rev
24 FROM pl_service_sirius_t
25 WHERE obj_id0 = svc.poid_id0);
26
27
28 c_evnt1_rec c_evnt1%ROWTYPE;
29
30 BEGIN
31 NULL;
32 END;
33 /

Warning: Procedure created with compilation errors.

SQL>
SQL> sho err
Errors for PROCEDURE TEST0312:

LINE/COL ERROR
-------- -----------------------------------------------------------------
28/15 PL/SQL: Item ignored
28/15 PLS-00402: alias required in SELECT list of cursor to avoid

The query runs fine, but gives an error in a cursor. I am usihng aliase, I do not see any alias missing. Could anyone help please

duplicate column names