Forum Discussion

jcornelius's avatar
jcornelius
New Contributor III
5 years ago

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
pipeline
mbowen's avatar
mbowen
Employee
5 years ago

Hi Nick:

Jumping in on thread is perfectly fine. The Oracle Execute snap can’t invoke stored procedures. Can you tell me more about your requirement and how the Stored Procedure snap can’t handle it ?

Anendu's avatar
Anendu
New Contributor II
5 years ago

Hello Mbowen,

I am currently running Stored Procedure against SQL database using JDBC execute SNAP and its returning me on only the execution status .

DB Version :- SQL server 2017

Can you please help, How to run stored procedure in JDBC SNAP?

Thanks,
Anendu

  • mbowen's avatar
    mbowen
    Employee
    5 years ago

    Hi @Anendu

    Our Generic JDBC Execute doesn’t wrap a CallableStatement which is the typical object used to invoke a stored procedures. It allows registering out parameters, etc. However, we may be able to invoke a stored procedure if it has no output parameters and returns no result set – pretty restrictive!

    Your questions suggest that you do want to get results back. Please clarify ? As mentioned above, you can invoke a stored function in a SELECT. Nick shows how to invoke a stored procedure in an anonymous PL/SQL block to load a JSON blob, but that’s Oracle – nevertheless, all success stories helpful.

    So, tell me a bit more about your stored procedure. BTW, we do have SQL Server snap pack which has a Stored Procedure snap which has very good support for stored procedures.