Call stored procedure

[megamirio]

Is the a way to call stored procedure in koala: for example in SQL this are:

call someStoredProcedure('param1','param2'):

Thant you, in advance for help.

[mfwgenerics]

Hi Eugene,

Koala doesn't support stored procedures, but I am open to adding some support.

Does your use case require reading back results from your stored procedure? If so, indicate which of the following you will need:

• [ ] Out parameters
• [ ] Result sets
• [ ] Multiple result sets

As an aside, I would recommend against using stored procedures except as a last line of optimization.

If you are dead set on using them and you need a quick workaround, you could always downcast the io.koalaql.DataConnection to io.koalaql.jdbc.JdbcConnection and then access the jdbc property to use the JDBC prepareCall method directly.

[megamirio]

Thank you for answering my questions.

I'll use it.

On Wed, Feb 21, 2024, 12:06 mfwgenerics @.***> wrote:

Hi Eugene,

Koala doesn't support stored procedures, but I am open to adding some support.

Does your use case require reading back results from your stored procedure? If so, indicate which of the following you will need:

• Out parameters
• Result sets
• Multiple result sets

As an aside, I would recommend against using stored procedures except as a last line of optimization.

If you are dead set on using them and you need a quick workaround, you could always downcast the io.koalaql.DataConnection to io.koalaql.jdbc.JdbcConnection and then access the jdbc property to use the JDBC prepareCall method directly.

— Reply to this email directly, view it on GitHub https://github.com/mfwgenerics/koala/issues/63#issuecomment-1957328513, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIJ5Y26VTM6EQ2XYBQBHU7DYUYSQHAVCNFSM6AAAAABDTJGFROVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSNJXGMZDQNJRGM . You are receiving this because you authored the thread.Message ID: @.***>