Cannot pass `NULL` to stored procedure via raw query

[manika-khare]

Bug description

I am trying to call a stored procedure using prisma's queryRaw. The stored procedure accepts a parameter of type unqiueidentifier which can be null. It works fine when the param has some value, but it fails when null is passed.

It throws the following error:

Raw query failed. Code: `206`. Message: `Operand type clash: int is incompatible with uniqueidentifier`

How to reproduce

Expected behavior

It should run fine even when null is passed, as the stored procedure allows null.

Prisma information

// Add your schema.prisma

// Add your code using Prisma Client
prisma.$queryRaw`
    EXEC myStoredProc @name = ${name}, @id = ${id}
`

Environment & setup

• OS: macOS
• Database: SQL Server
• Node.js version: 14.21.2

Prisma Version

prisma                  : 4.13.0
@prisma/client          : 4.13.0

[janpio]

@manika-khare Can you please share the definition of the (or a reproduction example) stored procedure so we can play with this ourselves? Does the query work when you execute it manually via another database client?

[ayloncarrijo]

Same here. This only occurs when using SQL Server.