Stored procedure output

[JuchangGit]

How to obtain the status code and status information of a stored procedure ?

[mihaitodor]

Hey @JuchangGit, unfortunately the Connect sql_* components don't attempt to return any status information currently. I went through the database/sql package and it looks like the query Result only supports returning LastInsertId() and RowsAffected() which makes me wonder if there's any generic way of getting this status code that's portable across multiple drivers. For example, in the case of MSSQL, the denisenkom/go-mssqldb driver that's used in Connect seems to expose a driver-specific mechanism: https://pkg.go.dev/github.com/denisenkom/go-mssqldb#readme-return-status. If such custom mechanism needs to be used for each driver, then I think it's best to recommend maintaining a custom Connect component plugin on your end with the required enhancements.

[JuchangGit]

thank you for your answer