Forum Discussion
Hi All,
Any info how to call Sybase store procedure.
Hi @sanjaynayak
Please see other comments about restrictions invoking stored procedures using the Generic JDBC Execute snap. What kinds of stored procedures do you want to invoke? We don’t have a Sybase snap pack, but think SAP bought them 2010-ish. We do have an SAP HANA snap pack, but am really less familiar with it, but could find out more information.
- sanjaynayak4 years agoNew Contributor III
It’s sybase store procedure
- mbowen4 years agoEmployee
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.
- smudassir4 years agoEmployee
Your procedure doesn’t have any OUT params @sanjaynayak . Can you verify that once?