How can I execute a stored procedure from a Flow Action?

[Tuna]

I am trying to figure out how to call an Oracle Stored Procedure from a Flow Action JDBC step.

My script looks like this:

DECLARE
v_result varchar(22);
BEGIN
SCH."OurProcedure" ('P1', 'P2', 'P3', v_result);
END;

The error thrown says: "Given SQL statement is not SINGLE SQL statement."

I've also tried to add the keywords "declare" and "call" to the jdbc_operations MID Property, but it didn't change anything.

So what's the solution to call a SP from a JDBC step? 

Any ideas would be appreciated.

[dave11980]

Did you have any luck figuring this out?  I'm trying as well and not having any luck.  I've found documentation saying there should be a 'use stored procedure' checkbox but I don't see it on the jdbc step in flow designer.  

[Tuna]

Sorry to say, but there is right now no possibility to invoke a SPs from a Flow/Flow Action. That's very unfortunate. With classic workflow there was a very handy WF Activity to configure the SP invocation but for Flow's there is nothing.
Our workaround was to do an UPDATE on the DB table which then triggers the SP....