Error(10601,4): PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:

15 pts.
Tags:
Oracle 11g
PL/SQL
SQL development
When I'm compiling a package, I'm getting below error.
Error(10601,4): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin end function pragma procedure.
I'm using is Oracle 11g in SQL Developer.


Software/Hardware used:
PLSQL
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Something is wrong in your code. 

Post your code, then we can help. Just from error, lot of things can be.
Without code I can only guessing which part produce this error.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    You need to post your code for us to be able to offer any help.
    84,745 pointsBadges:
    report
  • Vimalkv
    It got resolved. I missed to close an inner block. Thank you.
    15 pointsBadges:
    report
  • rockkky
    DECLARE
    v_accno accounts.accno%type;
    v_type  char(1);
    v_amt   number(5);
    v_bal   accounts.bal%type;
    BEGIN
    v_accno :=&accno;
    v_type :='&TRtype';
    v_amt := &amount;
     if v_type= 'W' then
     select bal into v_bal from accounts where accno=v_accno;
     if v_amt>v_bal then
     dbms_output.put_line('insufficient balance');
     else
    update accounts set bal=bal-v_amt where accno=v_accno;
    end if;
    else if v_type='D' then
    update accounts set bal=bal+v_amt where accno=v_accno;
    else 
    dbms_output.put_line('invalid transactions');
    end if;
    commit;
    select bal into v_bal from accounts where accno=v_accno;
    dbms_output.put_line('available bal= '||v_bal);
    END;
    /

    i am getting error
    PLS-00103: Encountered the symbol ";" when expecting one of the following:
    if
    10 pointsBadges:
    report
  • pranika
    create or replace package body emp_detail is

      procedure proc_emp(dept in varchar2, salary in number)
    is
    begin
    insert into person values(empid,empname,dept,salary);
    end;


    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: