error: ORA-00936: missing expression
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: error: ORA-00936: missing expression

  1. #1
    Join Date
    Jan 2007
    Posts
    1

    error: ORA-00936: missing expression

    Hi,

    i am trying to write a basic procedure in oracle 10g. I also tried to find out the exact error

    error: ORA-00936: missing expression

    This is what i have tried in SQL *Plus

    SQL> create procedure jjj
    2 as
    3 begin
    4 select CountryCode from Country;
    5 end;
    6 /

    Warning: Procedure created with compilation errors.

    AND therefore tried to check the exact error

    SQL> select Line,
    2 Position,
    3 Text,
    4 from USER_ERRORS
    5 where Name = 'jjj'
    6 and Type = 'PROCEDURE'
    7 order by Sequence;
    from USER_ERRORS
    *
    ERROR at line 4:
    ORA-00936: missing expression

    THANKS,
    SRI

  2. #2
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    select CountryCode from Country;
    Select CountryCode into Var_name from Country; (where clause is necessary if you have multiple rows)
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width