Query string argument of EXECUTE is null PostgreSQL procedure call

Queries and Resources
1

Hello everyone,

I am calling a store procedure on the submit button of the form and I am seeing this error

fn_land_search_v1: {“status”:400,“message”:“query string argument of EXECUTE is null”,“error”:true}

fn_land_search_v1 = procedure name

The procedure is working fine in PostgreSQL but its not working when call procedure from retool

procedure execution call from PostgreSQL

select * from land_search_v1 (’’,’’,’’,’’,’’,’’,’’,’’,’’,‘0’,’’,‘0’,’’,‘0’,’’);

procedure input multiple parameters which come from retool form and on submit button procedure is supposed to execute.

Any help will be appriciated.

Thanks

2

Hey there @wmg91! Do you have your Postgres resource configured to disable converting queries to prepared statements? That might be the issue!

3

Hi @justin

Thanks for reaching me out

The configuration which you mentioned is not the case here

I am not writting a dynamic SQL within the retool, I am just calling a PostgreSQL function which is already created.