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