B4J Question Microsoft sql (mssql) running store procedure

[victormedranop]

hi, I am trying to run an store procedure with declaration parameter,
but a haven't found the way to do that.

anyone with and working example. I can connect, run query but no lock with store procedure.
I am using mssql-jdbc-6.2.2.jre8.

sample procedure

DECLARE @RC int
DECLARE @CodigoCliente varchar(8)='10000180'
 EXECUTE @RC = [odbcRead].[__OrdenesIDIS] 
   
@CodigoCliente
GO

thanks,

Victor

 

[Erel]

Might be helpful: https://www.b4x.com/android/forum/threads/sql-stored-procedure-with-1-parameter.57726/#post-363352

 

[keirS]

I wrote a library to call stored procedures. Although the example is MySQL it will work with any JDBC driver.

https://www.b4x.com/android/forum/threads/sql-simplyfying-calling-stored-procedures.73181/#content