Question

Returning multiple records from Function

Workflow

Updated February 11, 2015

asked on February 10, 2015

Is it possible to return multiple records from an Oracle Function into LF Workflow using the custom query action? If so, what cursor or collection type does workflow expect?

0 0

Replies

replied on February 10, 2015

You can iterate through the result set of a custom query with the For Each Row activity.

0 0

replied on February 10, 2015

Does it matter what the return type is from the Function?

0 0

replied on February 10, 2015

That would depend on what you're trying to do with the values next.

0 0

replied on February 10, 2015 • Show version history

There is an ODBC connection to the Oracle. I have a Package that contains a Function that accepts two parameters and returns a sys_refcursor of IDs that are VARCHAR2 typed. I would like to iterate though the records and preform various actions. What is the syntax I need to put in the Custom Query to do this?

0 0

You are not allowed to follow up in this post.

Question

Question

Returning multiple records from Function

Replies

Sign in to reply to this post.