3. Statements : OpenROAD SQL Statements : Execute Procedure Statement : Examples—Execute Procedure Statement
 
Share this page                  
Examples—Execute Procedure Statement
Assume the following database procedure definition:
create procedure myproc
          (emp_name = varchar(256) not null, emp_no = integer not null,
           emp_terminated = integer not null) =
begin
          processing statements
end
Then execute the procedure myproc:
execute procedure myproc(emp_name = 'joshw',
          emp_no = 12, emp_terminated = byref(EmpIsTerminated));