I created a simple Databricks procedure that should return a single value."SELECT 1 AS result;"

When I call this procedure from my .NET API using ExecuteReader, ExecuteAdapter, or ExecuteScalar, the call completes without any errors, but no rows are returned.Has anyone experienced this issue or found a workaround? I had appreciate any guidance on how to properly retrieve results from Databricks procedures through the Simba ODBC driver