Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00201: identifier 'LIDS.NEXT' must be declared and PLS-00201: identifier 'LIDS.DELETE' must be (Windows XP DB 9i - forms 6i)
PLS-00201: identifier 'LIDS.NEXT' must be declared and PLS-00201: identifier 'LIDS.DELETE' must be [message #377713] Wed, 24 December 2008 08:09 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
i guyz,

i have below tables

emp table

empid
deptid
emp_name
work_location
date_of_join
emp_status
date_status

terminate table

empid
deptid
emp_name
work_location
t_date


anyone help me to find out this error. even i declared

48/7 PL/SQL: Statement ignored
48/13 PLS-00201: identifier 'LIDS.NEXT' must be declared
50/5 PLS-00201: identifier 'LIDS.DELETE' must be declared
50/5 PL/SQL: Statement ignored

CREATE OR REPLACE PACKAGE PK_TRIGGER IS


PROCEDURE PR_BS;


PROCEDURE PR_ARIU(i_nEmpId IN NUMBER);


PROCEDURE PR_AS;


END;

Package created.


1 create or replace package body pk_trigger is
2 type tdata is table of number index by binary_integer;
3 ldata tdata;
4 procedure pr_bs is
5 begin
6 ldata.delete;
7 end pr_bs;
8 procedure pr_ariu(i_nempid in number) is
9 ipos pls_integer:=ldata.count+1;
10 begin
11 ldata(ipos):=i_nempid;
12 end pr_ariu;
13 procedure pr_as is
14 cursor cremp(i_nempid in number) is
15 select *
16 from emp
17 where empid=i_nempid;
18 recemp cremp%rowtype;
19 ipos pls_integer;
20 begin
21 ipos:=ldata.first;
22 loop
23 exit when ipos is null;
24 -- do whatever you want with the data in the record
25 open cremp(ldata(ipos));
26 fetch cremp into recemp;
27 if cremp%found then
28 if ':new.emp_status'='terminate' then
29 delete from emp
30 where empid=ldata(ipos);
31 insert into terminate (
32 empid,
33 deptid,
34 emp_name,
35 work_location,
36 t_date
37 ) values (
38 recemp.empid,
39 recemp.deptid,
40 recemp.emp_name,
41 recemp.work_location,
42 sysdate
43 );
44 end if;
45 end if;
46 close cremp;
47 -- process next record
48 ipos:=lids.next(ipos);
49 end loop;
50 lids.delete;
51 end pr_as;
52* end pk_trigger;

Regards
Re: PLS-00201: identifier 'LIDS.NEXT' must be declared and PLS-00201: identifier 'LIDS.DELETE' must [message #377724 is a reply to message #377713] Wed, 24 December 2008 11:51 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
PK_TRIGGER has a dependency on package LIDS. Create package LIDS first.
Re: PLS-00201: identifier 'LIDS.NEXT' must be declared and PLS-00201: identifier 'LIDS.DELETE' must [message #377729 is a reply to message #377713] Wed, 24 December 2008 12:16 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You have 141 posts to date and you still aren't formatting your posts?

Please review the OraFAQ Forum Guide on how to format your posts correctly.
Re: PLS-00201: identifier 'LIDS.NEXT' must be declared and PLS-00201: identifier 'LIDS.DELETE' must [message #377779 is a reply to message #377713] Thu, 25 December 2008 02:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous post:
Michel Cadot wrote on Mon, 22 December 2008 15:02
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Always post your Oracle version (4 decimals).

Also always post a Test case: create table and insert statements along with the result you want with these data.

...

Regards
Michel

Re: PLS-00201: identifier 'LIDS.NEXT' must be declared and PLS-00201: identifier 'LIDS.DELETE' must [message #377786 is a reply to message #377779] Thu, 25 December 2008 02:48 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It appears that some people learn it sooner, some later, some never.
Re: PLS-00201: identifier 'LIDS.NEXT' must be declared and PLS-00201: identifier 'LIDS.DELETE' must [message #377796 is a reply to message #377786] Thu, 25 December 2008 03:20 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then some do not deserve any help. Sad

Regards
Michel
Previous Topic: SWITCH-CASE
Next Topic: changing coulmn name in where caluse depending on value passed
Goto Forum:
  


Current Time: Wed Dec 07 12:38:44 CST 2016

Total time taken to generate the page: 0.24976 seconds