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