I see. I wanted to get some feedback from community to see if calling proc
before running sql makes sense in JdbcIO. If that doesn't make sense then I
can close this JIRA.
-Rui
On Tue, Feb 5, 2019 at 3:00 PM Juan Carlos Garcia <jcgarc...@gmail.com>
wrote:
> 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
>>>
>>
