PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := . ( @ % ; not null range default character

Asked Dec 04 '19 at 12:33

Active Dec 04 '19 at 15:36

Viewed 789 times

I am not getting this error. Please help me out.

ORA-06550: line 2, column 12: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := . ( @ % ; not null range default character

Please find a link for more info.

I have created a table whose name is Scores and inserted score value in it. My problem is that I want to calculate the total of scores who is prime number and less than 100.

edited Dec 04 '19 at 15:36

Barbaros Özhan

59,113
10
31
55

asked Dec 04 '19 at 12:33

Prajakta Kale

2

your code works without exception: https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=69f95538138c34063b1544e2b2d47bdc – hotfix Dec 04 '19 at 12:43
But I am getting the above error in another environment. – Prajakta Kale Dec 04 '19 at 12:51
Where are you executing the script? – Ergi Nushi Dec 04 '19 at 12:59
@ErgiNushi sqlfiddle – Prajakta Kale Dec 04 '19 at 13:00
2

have a look at [PL/SQL on sqlfiddle](https://stackoverflow.com/questions/11483450/pl-sql-on-sqlfiddle) – hotfix Dec 04 '19 at 13:04
It works good in Oracle environment, why bother worrying why doesn't it work on sqlfiddle? – Ergi Nushi Dec 04 '19 at 13:04
I am not sure about it. Actually I just google for plsql fiddle online and I get a link to SQL fiddle. – Prajakta Kale Dec 04 '19 at 13:04
1

@hotfix 's link will do the trick. – Ergi Nushi Dec 04 '19 at 13:05

PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := . ( @ % ; not null range default character

0 Answers0