procedures problem

• • Reply

  17 years ago

  by koko

  konstantin

  skopie, Macedonia, United States

  Joined 17 years ago

  When i try to create procedure in oracle i got compilation errors. Even for
  the simpliest procedure like:
  

  
  create procedure brisis() as
  begin
  delete from Some_Table;
  end;
  

  
  First i tried through SQLPlus, and then in Oracle Console.
  It doesn't seem that i make any mistake but in SQLPlus i got this:
  Warning: procedure created with compilation errors.
  

  
  When i complile it i almost always got this error:
  'Encountered the symbol ")" when expecting one of the following: <an identifier>
  <a double-quoted delimited-identifier> '
  Where i might make a mistake?

  Report abuse
• • Reply

  17 years ago

  by doodle

  Aidan Walsh

  , Ireland

  Joined 18 years ago

  I havn't done a lot of PLSQL, but whats the "as" about. Looks to me like the source of the problem.

  Report abuse