Skip to content

queryRaw Error when calling SP or Function #2679

@nicosampler

Description

@nicosampler

When I try to get the results for an SP or a function like:

queryRaw("CALL increaseShopCounter()"); or queryRaw("select callIncreaseShopCounter();")

it fails with an undescriptive message:

prisma:query select callIncreaseShopCounter(
        15, 
        79,
        5
      ) as issuedId
PrismaClientKnownRequestError: Raw query failed. Code: `N/A`. Message: `N/A`
    at PrismaClientFetcher.request (/home/nicosampler/develop/cauda/node_modules/@prisma/client/runtime/index.js:1:148505)
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (internal/process/task_queues.js:97:5) {
  code: 'P2010',
  meta: { code: 'N/A', message: 'N/A' }
}

Both SP and Function return values when executing them directly.

DB: MySql
Prisma:
"@prisma/cli": "^2.0.0-beta.8",
"@prisma/client": "^2.0.0-beta.8",

Metadata

Metadata

Assignees

Labels

bug/2-confirmedBug has been reproduced and confirmed.kind/bugA reported bug.tech/enginesIssue for tech Engines.topic: raw$queryRaw(Unsafe) and $executeRaw(Unsafe): https://www.prisma.io/docs/concepts/components/prisma-cli

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions