Top "Pls-00103" questions

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:

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_…

oracle pls-00103
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 "…

oracle plsql pls-00103
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 …

oracle function plsql user-defined-functions pls-00103
Oracle function compilation error PLS-00103 (Encountered the symbol "SELECT" ...)

I receive the following error when I compile this function: Compilation errors for PROCEDURE INV.USP_MSC_MODIFICA_ESTADO Error: …

oracle syntax plsql compiler-errors pls-00103
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 …

plsql oracle10g oracle-xe pls-00103
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 …

oracle plsql pls-00103
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 …

oracle plsql pls-00103
PLS-00103 while creating 2 packages PLSQL

im trying to create 2 package body's in plsql. This is my code: SET SERVEROUTPUT ON CREATE OR REPLACE PACKAGE p_…

plsql oracle11g oracle-sqldeveloper pls-00103