I believe this is not a missing feature, as the question is more inclined
toward what do you expect from this procedure?
Like reading back a ref cursor into a PCollection, or just doing an insert
/ update via the sp.
Going forward on the jdbc realm you just need to create a prepared
statement with something like this:
{call procedure_name(?, ?, ?)}
But then question is what do you expect from it?
BTW JdbcIO is just a very simple ParDo which you can create your own when
dealing with anything special from oracle.
Best regards
JC
Am Di., 5. Feb. 2019, 23:03 hat Rui Wang <[email protected]> geschrieben:
> Assuming this is a missing feature. Created
> https://jira.apache.org/jira/browse/BEAM-6525 to track it.
>
> -Rui
>
> On Fri, Jan 25, 2019 at 10:35 AM Rui Wang <[email protected]> wrote:
>
>> Hi Community,
>>
>> There is a stackoverflow question [1] asking how to call Oracle stored
>> proc in Beam via JdbcIO. I know very less on JdbcIO and Oracle, so just
>> help ask here to say if anyone know: does JdbcIO support call stored proc?
>>
>> If there is no such support, I will create a JIRA for it and reply to the
>> question.
>>
>> -Rui
>>
>> [1]:
>> https://stackoverflow.com/questions/54364783/how-to-call-an-oracle-stored-proc-in-apache-beam
>>
>
