Print Thread
PLS-00113: END identifier <name> must match <name>
#46577 03/20/13 03:18 PM
Joined: Nov 2004
Posts: 27
J
Member
OP Offline
Member
J
Joined: Nov 2004
Posts: 27
We have just upgraded ftom 9.4 to 10.01.169 and now when compling packages we are sometimes getting PLS-00113: END identifier <name> must match <name> errors

We can work round the problem by copying the spec and body into seperate SQL windows and running them seperately

Re: PLS-00113: END identifier <name> must match <name>
Jeff Ward #46582 03/20/13 05:43 PM
Joined: Jul 2003
Posts: 10
ITALY
S
Member
Offline
Member
S
Joined: Jul 2003
Posts: 10
ITALY
I have upgradet on 3 computers too, on the two Win7/64 I have the same problem, but only if the compiled object is owned by a different user. The original name in the END statement (the last END of the module) is replaced by P$number$ in the source copied to the database. The replaced number changes with avery run. (Examples: P$81698208$, P$10386360$). Additionaly the window with the error message disapears, only the status line "Compiled with errors" is visible. Closing the window and reopen using the source from database the entire message "PLS-00113:END identifier 'P$10386360$' must match..." is visible. (I have not packages but procedures and functions.) BTW: On the computer with Win/XP the problems doesn't exist.


Last edited by sthaler; 03/21/13 08:52 AM. Reason: added some detail
Re: PLS-00113: END identifier <name> must match <name>
sthaler #46595 03/21/13 10:21 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you go to Tools > Preferences > Program Window and disable the "Safe compilation" option? Let me know if this helps.

If this helps, can you send me an example of such a package?


Marco Kalter
Allround Automations
Re: PLS-00113: END identifier <name> must match <name>
Marco Kalter #46599 03/21/13 12:17 PM
Joined: Nov 2004
Posts: 27
J
Member
OP Offline
Member
J
Joined: Nov 2004
Posts: 27
We are typically using either system or a proxy connection for the compiliaction of these packages

We have tried changing the settings as suggested and this seems to work

As a test (with the temp option re-enabled) i have just created a very simple package as follows:

create or replace package JWTEST01 is
PROCEDURE T1 ;
end JWTEST01;

create or replace package body JWTEST01 is
PROCEDURE T1 IS
v_count NUMBER ;
BEGIN
v_count := 1 ;
END T1 ;
end JWTEST01;

When compiled it failed to create the body and the end statement on the header changed to a temporary name as below:

create or replace package cbs.JWTEST01 is
PROCEDURE T1 ;
end P$689014;


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.068s Queries: 14 (0.024s) Memory: 2.5128 MB (Peak: 3.0417 MB) Data Comp: Off Server Time: 2024-05-18 13:53:30 UTC
Valid HTML 5 and Valid CSS