Android Question Input Output Parameters Stored Procedure (JdbcSQL)

[jgimenez]

Hello, i try to call a stored procedure in sql server using in/out parameters, but i dont know how to set in or out direction.
My code:

Private Sub Save_Record
    Dim New_code As Long
    Dim Code_Description As String
    Dim Inserted_Code As Long
    
        Try
        New_code=txt_code
        Code_Description=txt_description.Text
        
        
        Dim cs As Object = mysql.CreateCallStatement("exec Save_Codes(?,?,?)", Array( New_code,Code_Description, Inserted_Code))
        Dim rs As JdbcResultSet = mysql.ExecCall(cs)
        rs.Close
        MsgboxAsync("Inserted Code is: ",  Inserted_Code)

    Catch
        MsgboxAsync("Error : "& LastException.Message,"Error")
    End Try
End Sub

Here New_code and Code_Description are Input parameters, but Inserted_Code is a output parameter.
How i can can I retrieve this OUT parameter's value ?

Thanks!

(sorry for my english)

 

[Erel]

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