There seems to be a parsing problem with calling a procedure having an empty
parameter list.

When I execute the following procedure definition:

create procedure sp_clear_Sudoko_puzzle()
begin
 execute immediate
 '
   update SudokoGrid set
   column1 = null,
   column2 = null,
   column3 = null,
   column4 = null,
   column5 = null,
   column6 = null,
   column7 = null,
   column8 = null,
   column9 = null
 ';

 -- Update the Sudoko base table
 call sp_update_Sudoko();
end

I'm getting the following error:

ElevateDB Error #700 An error was found in the statement at line 18 and
column
25 (Expected expression but instead found ))

Calling procedures having parameters works fine.

Ole Willy Tuv

Ole,

<< There seems to be a parsing problem with calling a procedure having an
empty parameter list. >>

Yep, it wants parameters in all cases.

--
Tim Young
Elevate Software
www.elevatesoft.com