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