Unable to Call Stored Procedure from Postman

[girishvenkata14]

Environment

• PostgreSQL version: "PostgreSQL 12.5 (Ubuntu 12.5-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit"
• PostgREST version:
• Operating system:

Description of issue

Unable to call the stored procedure from postman and getting below errors. Could you please help

Below is the SP used:

Below is the issue when calling stored procedure using Get in postman:

Below is the issue when calling stored procedure using Post in postman

1. Using CALL

2)Using JSON

[wolfgangwalther]

Stored Procedures are not supported. You need to create this as a function, not a procedure.

[steve-chavez]

For reference: #1210.

Postgres 11 procedures have limitations, AFAICT you don't need them unless you want to start a transaction inside them. So changing your proc to a function should work fine - CREATE FUNCTION instead of CREATE PROCEDURE.