CODEWITHSUNDEEP
oracle-databaseplsql
stephanie
stephanie

Reputation: 75

Error(7,1): PLS-00103: Encountered the symbol "BEGIN"

I am a new PL/SQL user. I tried to create a procedure and run it like:

create or replace procedure addp1(i in number) is

begin
  insert into t3 values (i,'xxxx');
end addp1;

begin
addp1(99);
end;

but i got error: Error(7,1): PLS-00103: Encountered the symbol "BEGIN" in my log file. Can anyone help me fix this problem. Thanks

Upvotes: 2

Views: 23988

Answers (1)

Maheswaran Ravisankar
Maheswaran Ravisankar

Reputation: 17920

create or replace procedure addp1(i in number) 
is
begin
  insert into t3 values (i,'xxxx');
end addp1;
/* We have to actually push the block to the engine by issuing a '/' */
/

begin
addp1(99);
end;
/* Every PL/SQL Block needs this! */
/

Upvotes: 17

Related Questions