Questions tagged [pls-00103]

PLS-00103 is an error message in Oracle, which points to a wrong symbol in the query: Encountered the symbol "$symbol" when expecting one of the following:

The complete error message reads like this:

PLS-00103: Encountered the symbol "$symbol" when expecting one of the following:
( begin case declare end exit for goto if loop mod null
pragma raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
continue close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe purge )

73 questions
0
votes
2 answers

Procedure returning PLS-00103: Encountered the symbol "EOF" when expecting

I'm new to PL/SQL, doing a homework question where I need to write a procedure that returns an error message based on day of week/time but I am stuck on a basic thing before I get to that point: I have written the following: CREATE OR REPLACE…
Mya Jane
  • 1
  • 2
0
votes
2 answers

Pl SQL Oracle PLS-00103: Encountered the symbol "CREATE"

this code takes input for zipcode, city, and state and then inserts that into the table created Address. Prior to inserting data it will check if the zipcode is already in the table, if so calling procedure(error) to display an error code. Im…
rob
  • 43
  • 1
  • 2
  • 7
0
votes
2 answers

Can't compile PL/SQL in oracle sql developer

This is my package: CREATE OR REPLACE PACKAGE DEPARTMENT_INFO AS TYPE t_dep_loc IS RECORD(region_name regions.region_name%type, country_name countries.country_name%type, state…
user4080876
0
votes
2 answers

I'm getting this error when ever I'm executing my stored procedure " PLS-00103"

I'm trying to execute stored procedure, I'm getting stuck in 54 line 'EXECUTE IMMEDIATE' basically. I'm passing SQL statement into for loop.Please let me know I'm doing wrong somewhere? CREATE OR REPLACE Procedure DE_DUP_PROC (Dy_File_Name in…
user4993731
0
votes
2 answers

oracle - PLS-00103 & ORA -06550 on procedures

I'm getting the above error while trying to run a simple PL/SQL program that uses procedures. I dont know what went wrong, please help out. declare create or replace procedure palindrome (x in number,y out number) is i integer; j…
Vivek acm
  • 3
  • 3
0
votes
1 answer

SQL - Encountered the symbol "EXCEPTION" when expecting one of the following

I'm trying to create a procedure. When I run my code I get the error: 21/1 PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma …
sqlman22
  • 1
  • 1
  • 1
0
votes
1 answer

While compiling trigger in Oracle SQL throwing error as table or view doesn't exist

Also following error coming near "declare @empsal" as PLS-00103 :Encountered the symbol "@" when expecting one of the following... My tables do exist in the database. My trigger: create or replace TRIGGER leavemastertrg After INSERT ON…
Saro
  • 1
  • 1
0
votes
1 answer

Error PLS-00103 while compiling a function

I get this error when I compile my function. PLS-00103: Encountered the symbol "*" when expecting one of the following: := . ( @ % ; Here is the code: CREATE OR REPLACE FUNCTION IncreaseSalary (para_empid IN employee.employeeid%TYPE,…
0
votes
1 answer

Oracle dbms_scheduler.create_job Error

I am trying to create a simple scheduled event in an oracle 10g database. I have been trying to use dbms_scheduler.create_job. Here is the script I wrote: begin dbms_scheduler.create_job ( job_name => 'disengagementChecker', job_type =>…
user3412162
  • 283
  • 1
  • 4
  • 6
0
votes
2 answers

PLSQL procedure error

I get the below error while executing code create or replace function contact_restriction_function(obj_schema varchar2, obj_name varchar2) return varchar2 is v_contact_info_visible hr_user_access.contact_info_visible%type; begin -- Here…
0
votes
1 answer

PLS-00103 Encountered the symbol " " error in CASE

I have simply written CASE statement in the procedure as below (case when (T1.DEVICEHOLD = 'Z1' or T2.ISHOLD = 1) then 1 else 0 END) AS HOLD But when I'm compling procedure its giving an error Compilation errors for PACKAGE BODY…
cool_taps
  • 340
  • 1
  • 4
  • 16
0
votes
1 answer

ORA-06550, PLS-00103, ORA-06512 on function

I have no idea what to do. I wrote a function, compiled it with no errors but then when I run the code I got: ORA-0650: line 3, column 14: PLS-00103: Encountered the symbol "/" when expecting one of the following: := . ( @ % ; not null range…
Yoni Levy
  • 1,562
  • 2
  • 16
  • 35
0
votes
2 answers

Syntax error in for loop

Error starting at line 1 in command: DECLARE x NUMBER := 0; counter NUMBER := 0; BEGIN FOR i IN 1..4 LOOP x := x + 1000; counter := counter + 1; INSERT INTO temp VALUES (x, counter, 'in OUTER loop'); END; END…
Abhiruchi Sharma
  • 55
  • 1
  • 2
  • 9
0
votes
1 answer

Procedure with looping and execute immediate

Recently I have started preparing datamarts for regular reporting process, and tried to make some use of procedures with parameters. So I read this guideline and tried to replicate but confused with error in compiling. Here is my code: create or…
user2074685
  • 29
  • 1
  • 1
  • 6
0
votes
1 answer

Error on creating stored procedure under Oracle - PLS-00103

Im trying to create a stored procedure that calls another a number of times. This is done so by using a for each loop. All the development is under oracle sql developer Version 3.0.04. CREATE OR REPLACE PROCEDURE Z_INBILLABILITYSERV IS…
FEST
  • 813
  • 2
  • 14
  • 37