How can i get stored procedure output value after run (JdbcSQL)?
B4X:
Private Sub CreateUser
Dim arr As List
Dim Ad As String = "[email protected]"
arr.Initialize
arr.Add(Ad)
Dim obj As Object = SQL.CreateCallStatement("dbo.MobilMisafirOlustur(?)",arr)
Dim rs As JdbcResultSet= SQL.ExecCall(obj) 'Success run stored procedure
Dim IndexofColumn As Int = rs.ColumnCount 'I am getting 1
Dim ColumnName As String = rs.GetColumnName(0) 'I am getting "UserName" (this is right)
Dim OutPutValueWithIndex As String = rs.GetString2(0) '<<<<< I am getting error "java.sql.SQLException: No current row in the ResultSet."
Dim OutPutValueWithName As String = rs.GetString(ColumnName) '<<<<< I am getting error "java.sql.SQLException: No current row in the ResultSet."
End Sub