Call Procedure and function from PostgreSQL

1
  Why cause this problem? I have confuse why the error is column “Tokyo” does not exist. And how to connect procedure from postgresql to Mendix? Am I wrong with my method?
asked
4 answers
0

Hi PuoLim,

 

Did you configure the postgreSQL DB in you configuration correctly?

 

Creating a variable is not adding something to the database.

For that you need to Create (and Commit) an object.

 

However, the way you want to interact with a procedure in your database, you probably want to use the Database Connector module. You can find the documentation here: https://docs.mendix.com/appstore/connectors/database-connector/

This module will allow you to specify how you interact with the database, for example these actions will be available.

The CALL statement can be implemented through the Execute Query action.

 

 

Hope this will help you.

 

Peter

answered
0

This is my current problem, may you help me?This is my current problem, may you help me?

answered
0

'{ARRAY[("1", "DMS", "DMS", true)]::segments[]}' this seems to be a PHP call.

 

Can you not just use SQL like this: CALL create_site(1, 'DMS’, 'DMS’, true)

answered
0

Can you try this?

 

'CALL create_site( ''Tokyo'', array[1, "DMS", "DMS", true] );'

answered