Passing a variable to a stored procedure

Question

Is it possible to pass a variable to a stored procedure? I am pulling the deliveryid and setting it as a variable but when I execute the stored procedure, I am getting an error:

ODB-240000 ODBC error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Error converting data type nvarchar to bigint. SQLState: 37000

DeliveryId data type is an integer but I am not sure if the SQL is taking the variable literally.

Here is my logic:

EXEC [CDL].[dbo].[test] @deliveryid = [vars.deliveryId]

ccg1706 · Accepted Answer

Hi @kristenco4,

The above error is showing you that deliveryid is being treated as a nvarchar instead of an integer (bigint).

You will need to try to convert the variable befor passing it to a stored procedure. I would be somehitng like this:

EXEC [CDL].[dbo].[test] @deliveryid = CONVERT(BIGINT, [vars.deliveryId])

Alternatively, if it this does not work you can try CAST function.

Finally, I leave you with useful documentation:

CAST AND CONVERT (TRANSACT -Sql)

Create a stored procedure

Hope it helps, if you need more guidance please let me know.

Regards,

Celia

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded