OceanBase Embedded SQL in C (ECOB) uses the CALL statement to execute stored procedures. At present, ECOB supports only stored procedures that do not contain the OUT parameter.
Syntax:
EXEC SQL CALL (procedure_name) ( input argument ) ;
Sample statement:
// Create proc in OceanBase Database.
/*
create table test (c1 int);
create or replace procedure proc (inval in int)
as
begin
insert into test values(inval);
commit;
end;
*/
int inputVal = 0;
EXEC SQL CALL proc(:inputVal);