Is there a way that I can get hold of and use the results from calling a stored procedure in a SQL Executor?
My procedure seems to run fine, but I haven't been able to get anything out of the Result output port of the SQLExecutor. The stored proc queries a mapping table and returns either an existing id or a newly-created one (or an error).
My SQL looks something like this:
declare
ID number;
STATUS number;
ERRMSG varchar2(128);
begin
schema.get_new_id(@Value(obj_id),'@Value(table_name)',ID,STATUS,ERRMSG);
end;
Again, it seems to run fine, but I would like to use the output variables ID and STATUS on the feature farther along in the workflow (e.g. to set an attribute value).
Any assistance is appreciated.
Thanks!