I am attempting to query sql server using a stored...
# orm-help
m
I am attempting to query sql server using a stored procedure in prisma 3.8.
"Could not find stored procedure 'Case-Clinical.dbo.usp_ProviderSearch'.
I run the query on the database, everything is fine. I run it using prisma and I get that error message. I logged into the database using same user as prisma uses.
Copy code
// let results = await this.data.$queryRaw<ProviderSearch[]>`exec [dbo].usp_ProviderSearch 
      // @Search = ${input.search} ,
      // @City = ${input.city} ,
      // @PostalCode = ${input.postalCode} ,
      // @Specialty = ${input.specialty} ,
      // @Rating = ${input.rating} ,
      // @Latitude = ${input.latitude} ,
      // @Longitude = ${input.longitude} ,
      // @DistanceMiles = ${input.distanceMiles} 
      // `

      let results = await this.data.$queryRawUnsafe<ProviderSearch[]>(`exec [Case-Clinical].[dbo].usp_ProviderSearch`)