Snap for JDBC that runs stored procedure and returns status and results...like SQL execute snap
I need a snap like the SQL execute snap that returns both the results and the status but is for JDBC stored procedure…does one exist
Forum Discussion
It’s sybase store procedure
I know you had mentioned Sybase, and the reference to SAP HANA clearly indicates that I have less experience with this DB, and not helpful to you. I’ve actually tagged another developer who has done some recent work with stored procedures across all of our snaps. So, you may hear some more from him.
Using a Sybase JDBC driver, we should be able to invoke a stored procedure, but again, there are some constraints using this snap. I can do a little more research, and maybe other dev will be able to say a bit more too.
Your procedure doesn’t have any OUT params @sanjaynayak . Can you verify that once?
Yes @smudassir , we are not expecting any out put, once store procedure get call, it will do what it supposed to be do in db level.
