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 <ruw...@google.com> 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 <ruw...@google.com> 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
>>
>

Reply via email to