Hi,
In one of my development work, I have to capture the out parameter value from a Oracle stored procedure call into one of the stambia variable. The stored procedure looks like:
sp_run_validation(p_batch_id in number, p_result out number);
I tried to call this stored procedure by passing nearly all types of variables(Metadata Vairable, Parameter Component, sqltoparameter variable etc) available in stambia designer but every time instead of binding the return value to the variable, it just puts the value of that variable in the stored procedure call.
Eg: I call the stored procedure like this,
Begin
sp_run_validation(${~/batch_id}$, ${~/result}$);
end;The actual call made to the database is:
Begin
sp_run_validation(100, );
end;
Since the initial value of ${~/result}$ is null, the second parameter is replaced by null.
Is there any method through which I can bind the return value form the out parameter of Oracle stored procedure to stambia variable?
Regards.
