Database Administration (MOSC)

MOSC Banner

PLS-00103: Encountered the symbol "end-of-file"

Hi,

On 11.2.0.4,

When I compile a procedure I receive:

SQL> ALTER PROCEDURE apps.SECONDPROC compile;

Warning: Procedure altered with compilation errors.

SQL> show error

Errors for PROCEDURE APPS.SECONDPROC:

LINE/COL ERROR

7/5   PLS-00103: Encountered the symbol "end-of-file" when expecting

     one of the following:

     begin function pragma procedure

Here is the code:

create or replace procedure secondproc as

 a number;

 procedure hello as

 begin

 execute immediate 'create table testvariables(id number,name1 varchar2(12))';

 -- execute immediate 'insert into testvariables values (1,''dd'');';

 end;

Thanks for help

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center