Stack Overflow
Stack Overflow

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
1 answer

in oracle sql im creating after delete insert into table but getting this error which PLS-00103: Encountered the symbol "DELETE"

CREATE TABLE Property ( Pid int, Branchid int, Ptype varchar(250), Paddress varchar(250), Pcity varchar(250), CurrentPrice number, Pstatus varchar(10), Pminprice number, Pmaxprice number, Agentid int, …
sarjil
  • 1
0
votes
1 answer

How to repair declare statement?

Could you help me, pls repair following SQL statement, I have error in first line. Thanks DECLARE @T_SYS_FROM SMALLINT,VARCHAR(8); SET @T_SYS_FROM = 20200922,DATE; SELECT T_SYS_FROM, N_D_AHDJ, N_FUND_ID, N_AHDJ, …
Jana Kajabova
  • 1
0
votes
1 answer

PLS-00103 error when using COMMENT statement in BEGIN ... END block in PL/SQL

Out of curiosity I'm attempting to use the COMMENT statement in a PL/SQL block. I'm using Oracle APEX 18.2 on an Oracle 11g database and in SQL Workshop I am able to execute the command by itself, but if I wrap it in a BEGIN ... END block then I get…
KyokoHunter
  • 387
  • 1
  • 4
  • 15
0
votes
2 answers

Oracle stored procedure runtime error with pls 00103

(Update 2019/07/23) New way to call procedure SET SERVEROUTPUT ON declare variable res sys_refcursor; begin my_schema.SP_READ_MEMBER('11223344', '1970/01/01', res); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line ('ERROR ' ||…
RRTW
  • 3,160
  • 1
  • 35
  • 54
0
votes
1 answer

Compilation Errors in Procedure of Oracle 10g

I receive the following error when I compile this function: Compilation errors for PROCEDURE HAR.REPORT_INCOME_PROC PLS-00103: Encountered the symbol "" when expecting one of the following I have try to google for that, but I cant my fault...…
TimesSlience
  • 1
  • 2
0
votes
0 answers

Oracle SQL ORA-06550 & PLS-00103 Errors

When running the code at the bottom of this post, I receive the following error report. Could someone please point out to me where the issue(s) lies? Thank you for your help. Error report - ORA-06550: line 12, column 8: PL/SQL: ORA-00942: table or…
user5491858
  • 23
  • 5
0
votes
1 answer

oracle procedure ORA-06550, PLS_00103

I have a procedure defined as: PROCEDURE Import_Invoice ( as_Directory_Name_Invoice_Data in varchar2, as_File_Name_Invoice_Data in varchar2, as_Directory_Name_Invoice_Log in varchar2, al_processid out number, …
Heinz
  • 913
  • 4
  • 12
  • 22
0
votes
1 answer

PLS-00103 Encountered the symbol "number"

I'm trying to get the exception for negative values for the loan balance, but I got this error. Errors for PROCEDURE PRC_PAYMENTS: LINE/COL ERROR 8/11 PLS-00103: Encountered the symbol "NUMBER" when expecting one of the following: …
Kenneth
  • 5
  • 6
0
votes
2 answers

PLSQL Nonsense (?) Error PLS-00103 in Package and Package Body

I'm getting what I believe to be a nonsensical error for a procedure. CREATE OR REPLACE PACKAGE reg AS TYPE ref_cursor IS ref cursor; ... FUNCTION show_enrollments RETURN ref_cursor; PROCEDURE return_prereqs (param_dept_code…
935
  • 59
  • 1
  • 10
0
votes
2 answers

Oracle case statement with variable

I have a requirement which says run one query if today is monday, else run another query. For this I have wrote the below query, but I am getting the below error message. DECLARE l_today_date VARCHAR2(15) := TO_CHAR(SYSDATE, 'DAY'); BEGIN …
Dileep
  • 126
  • 1
  • 4
  • 14
0
votes
2 answers

PLS-00103: Encountered the symbol "INSERT" Need help finding cause of error pl/sql

I hate doing this but my SQL is weak that I'm not able to troubleshoot using the error message to correct the syntax. Can someone help check my syntax and see what is causing the error? I thinking it has something to do with the DECLARE and BEGIN.…
idkfa.bfg2
  • 49
  • 1
  • 6
0
votes
3 answers

ORA-06550 PLS-00103 error:encountered the symbol

create or replace PROCEDURE empl_info(ename VARCHAR2,empid OUT NUMBER,empcount OUT NUMBER,empname OUT VARCHAR2) IS BEGIN SELECT COUNT(emp_name) INTO empcount FROM employees WHERE emp_name=ename; SELECT emp_name, emp_id INTO empname,empid FROM…
prabhu r
  • 233
  • 2
  • 10
  • 16
0
votes
2 answers

Encountered the symbol "EXCEPTION" error in stored procedure

I am programming a procedure in an Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production. I have an exception inside a LOOP because I don't want the procedure to exit the LOOP if an exception is thrown. create or replace…
en Lopes
  • 1,863
  • 11
  • 48
  • 90
0
votes
2 answers

PLS-00103: Encountered the symbol "END" when expecting + & = etc

This is my code: DECLARE v_grade CHAR(1) := UPPER('&grade'); appraisal VARCHAR(20); BEGIN appraisal := CASE v_grade WHEN 'A' THEN 'Excellent' WHEN 'B' THEN 'Very Good' WHEN 'C' THEN 'Good' WHEN 'No such grade' END; DBMS_OUTPUT.PUT_LINE('Grade:…
Dries Jans
  • 107
  • 1
  • 11
0
votes
1 answer

Oracle Stored procedure to insert non-duplicate values and foreign key constraint consideration

My requirement is to write a procedure to add values in COUNTRIES table. But, first it should check if corresponding values exist in another table, REGIONS as it is a foreign key. Only if the values exist is the insert into COUNTRIES table allowed.…
user3400060
  • 299
  • 3
  • 9
  • 23
1 2
3
4 5