Re: How to call Oracle stored proc in JdbcIO

2019-02-05 Thread Rui Wang
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 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

Re: How to call Oracle stored proc in JdbcIO

2019-02-05 Thread Juan Carlos Garcia
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 wit

Re: How to call Oracle stored proc in JdbcIO

2019-02-05 Thread Rui Wang
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 wrote: > I believe this is not a missing feature, as the question i