data-api-builder icon indicating copy to clipboard operation
data-api-builder copied to clipboard

[Bug]: `numeric` data type not supported as a parameter for a stored procedure

Open Aniruddh25 opened this issue 1 year ago • 0 comments

What happened?

System.Data.Common.SqlDbType https://learn.microsoft.com/en-us/dotnet/api/system.data.sqldbtype?view=net-8.0 doesn't have a Numeric type, thats why we unfortunately see this error. The autodetection is done by querying sys.dm_exec_describe_first_result_set which gives back numeric from SQL. We will need to handle this discrepancy between these dependencies in DAB explicitly for this and other possible types which may be absent in System.Data.Common.SqlDataType

image

Version

main

What database are you using?

Azure SQL

What hosting model are you using?

Local (including CLI)

Which API approach are you accessing DAB through?

REST

Relevant log output

No response

Code of Conduct

  • [X] I agree to follow this project's Code of Conduct

Aniruddh25 avatar Feb 24 '24 00:02 Aniruddh25