Call oracle's procedure inside of an event

Developers Databases
#1

Hello,

I have a procedure with parameters in oracle, do you know how to achieve this task? I have tried sc_exec_sq without success:

sc_exec_sql("BEGIN APPLY_PLAN('2016', '98', '02'); END");

The following error is displayed:

Parse error: syntax error, unexpected ‘’ (T_ENCAPSED_AND_WHITESPACE), expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\Program Files (x86)\NetMake\v81\wwwroot\scriptcase\app\proy\APP\index.php on line 1089

Thank you in advance.

#2

I have confirmed that using [B]; /B breaks the compiled code generated by ScriptCase. However, still finding a way to call the procedure.

#3

Sc_exec_sql(“call yourproc()”);

#4

Works like a champ. Thank you!