CODEWITHSUNDEEP
oracle-databaseplsql
newbie
newbie

Reputation: 155

oracle plsql error while compiling package spec

create or replace
PACKAGE test_pkg 
IS
PROCEDURE abc_requests (p_xys IN NUMBER);                      
end test_pkg;

Hello my procedure name is abc_requests with just one parameter. Below is my error message, please help.

Error message:

Error(4,11): PLS-00103: Encountered the symbol " " 
when expecting one of the following:     
 <an identifier> 
 <a double-quoted delimited-identifier>    
 current delete exists prior

Upvotes: 0

Views: 153

Answers (1)

Alex Poole
Alex Poole

Reputation: 191570

You have used non-breaking spaces in your statement, instead of plain spaces. If you copy and paste the code from the page as it is displayed above it will work. If you edit the question and copy the original code it will not.

You can use the dump() function (or a decent text editor) to see what the code actually contains:

select dump('PROCEDURE abc_requests (p_xys IN NUMBER);',16) from dual;

DUMP('PROCEDURE ABC_REQUESTS(P_XYS IN NUMBER);',16)                                                                                              
--------------------------------------------------------------------------------------------------------------------------------------------------
Typ=96 Len=44: 50,52,4f,43,45,44,55,52,45,c2,a0,61,62,63,5f,72,65,71,75,65,73,74,73,20,28,70,5f,78,79,73,c2,a0,49,4e,c2,a0,4e,55,4d,42,45,52,29,3b
                                          ^^^^^                                                          ^^^^^       ^^^^^

I've highlighted the two problem characters, which are the multibye non-break space (in UTF-8).

Retype your code, or copy and paste from the question, or just change the non-breaking spaces to normal ones.

Upvotes: 4

Related Questions