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
45
votes
4 answers

PLS-00103: Encountered the symbol "CREATE"

What is the problem with this package as it is giving an error? CREATE OR REPLACE PACKAGE PKG_SHOW_CUST_DETAILS AS PROCEDURE SHOW_CUST_DETAILS( myArg VARCHAR2); END PKG_SHOW_CUST_DETAILS; CREATE OR REPLACE PACKAGE BODY PKG_SHOW_CUST_DETAILS…
Surya
  • 451
  • 1
  • 5
  • 6
21
votes
6 answers

create oracle package encountered PLS-00103: Encountered the symbol "CREATE"

I am writing an oracle package using Oracle sql developer, I got this compile error: Error(7,1): PLS-00103: Encountered the symbol "CREATE" . create or replace PACKAGE TestPackage AS FUNCTION beforePopulate RETURN BOOLEAN; FUNCTION…
Gary
  • 4,495
  • 13
  • 36
  • 49
5
votes
1 answer

Error PLS-00103 compiling user-defined function in Oracle

I'm trying to create a user defined function in Oracle that will return a DATE when given a text argument containing a date substring. I've tried a couple ways of writing this, and all seem to throw the same error: CREATE OR REPLACE FUNCTION…
Stew
  • 4,495
  • 6
  • 31
  • 41
5
votes
3 answers

PL/SQL: Error when creating sequence

I'm quite new to PL/SQL, and am using Oracle SQL Developer to write a procedure which uses a sequence to generate a primary key for some existing data, to write into another DB. The code in question is under NDA.. Essentially I have the…
iank
  • 800
  • 3
  • 10
  • 32
2
votes
2 answers

PLS-00103 when trying to call a procedure

When attempting to compile I am getting the following errors Error(16,8): PLS-00103: Encountered the symbol "SPROLLUPEXPENSEITEM" when expecting one of the following: := . ( @ % ; The symbol ":=" was substituted for "SPROLLUPEXPENSEITEM" to…
Little Foye
  • 23
  • 1
  • 3
2
votes
1 answer

PLS-00103 Error at end of function

Receiving the following error relating to a function: 'ERROR at line 20: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: end not pragma final instantiable order overriding static member constructor map 0.01…
user725236
  • 165
  • 2
  • 3
  • 9
2
votes
1 answer

ORA-06550 and PLS-00103

HI, I am using UNIX OS and working on oracle. I am getting the error message below E ORA-06550: line 1, column 8: PLS-00103: Encountered the symbol "" when expecting one of the following: begin function package pragma procedure subtype type use …
Sachin
  • 20,805
  • 32
  • 86
  • 99
2
votes
1 answer

PLSQL error - PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of

I'm new to PL/SQL, needed your help to resolve the below error. while trying on a script I keep receiving the below. I tried to resolve and spend some time to get through, but was in vain. Answer/resolution will be much appreciated, Thank you…
faris_a
  • 21
  • 1
  • 3
1
vote
0 answers

How do I troubleshoot the "PLS-00103: Encountered the symbol 'end-of-file' when expecting one of the following" error in Griddb?

My Code: CREATE OR REPLACE PROCEDURE get_employee_name (p_id IN NUMBER, p_name OUT VARCHAR) AS BEGIN SELECT name INTO p_name FROM employees WHERE id = p_id; END; / BEGIN get_employee_name(1, v_name); DBMS_OUTPUT.PUT_LINE('Employee name: '…
Hajar S
  • 41
  • 3
1
vote
1 answer

ORA-06550 PLS-00103: Encountered the symbol "" when expecting one of the following: := . ( @ % ;

I see many similar questions, but I can't see what could be wrong here. I have the following very simple Oracle SP: create or replace PROCEDURE "SP_PERSONAS_PADRON_BIENES" ( pcod_organizacion in number, pnum_cedula in varchar2, pnum_bienes in…
jtorrescr
  • 627
  • 4
  • 13
1
vote
2 answers

Oracle SP : PLS-00103: Encountered the symbol "`" when expecting one of the following:

EXECUTE IMMEDIATE 'UPDATE GDW_ARC_CDM.LND_DIM_GEO SET DESCRIPTION_COLUMN = REPLACE( DESCRIPTION_COLUMN, '`', '''' ) WHERE CNTRY_ID = 'KR' AND SRC_ID = 'KR_RET' AND DESCRIPTION_COLUMN LIKE '%`%''; COMMIT; I'm trying to add…
pawan kumat
  • 11
  • 1
1
vote
2 answers

PLS-00103 error for procedure

I have 2 servers (one for testing, one for production), both have the following Oracle packages (identical output on both of them for SELECT * FROM V$VERSION; : Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production PL/SQL Release 9.2.0.3.0 -…
Exeter
  • 11
  • 1
  • 2
1
vote
1 answer

PLS-00103 Error in PL/SQL Developer

Note: I do not have this problem when using Oracle SQL Developer:: - But it is not the Standard here. So i must find a way to do this in PL/SQL Developer When attempting to use PL/SQL developer (PL/SQL Developer - the program) to dynamically drop…
BGDev
  • 135
  • 1
  • 8
1
vote
0 answers

Q : Oracle : [Error] PLS-00103 (13: 29): PLS-00103: Encountered the symbol "CROLE" when expecting one of the following: (

i wanna ask again about my procedure, this is the example: first, CREATE OR REPLACE procedure proc10(pnik in varchar2, pposition in varchar2) IS v_error_message varchar2(255); CURSOR cuser IS SELECT userid FROM mstuser WHERE nik = pnik; CURSOR…
Ade Rianto
  • 31
  • 6
1
vote
1 answer

How to call a stored function from a stored procedure and store the return value

When I do this in my stored procedure: create procedure Proc1( startdate IN TIMESTAMP, ENDDATE IN TIMESTAMP ) declare test_result number --line 55 test_result:=Stored_function1(startdate,enddate,11,13); --line 56 END; SQL…
Dylan Czenski
  • 1,305
  • 4
  • 29
  • 49
1
2 3 4 5