MuleSoft · Database Connector
Unsupported feature 'call'
Short answer
Snowflake returns Unsupported feature 'call' when a callable statement in Database Connector is written with curly brackets. Write the statement without them, for example call doubleMyInt(:myInt).
VerifiedLast verified
01Error text
net.snowflake.client.jdbc.SnowflakeSQLException: Unsupported feature 'call'02Likely causes
- The callable statement uses curly brackets
{and}.
03How to fix it
- Open the Stored procedure operation and find the SQL text.
- Remove the curly brackets, so the statement reads like
call doubleMyInt(:myInt). - Run the flow again.
04Official documentation
→Related errors
- DB:BAD_SQL_SYNTAXDB:BAD_SQL_SYNTAX means the SQL query you gave Database Connector contains invalid syntax. Correct the statement for your database, and check any part of it that is built dynamically.
- DB:QUERY_EXECUTIONDB:QUERY_EXECUTION means the database accepted the connection but the execution of the query failed. Turn on verbose logging for Database Connector to see the database's own message, then fix the query, its parameters or its timeout.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for MuleSoft work:Open MuleSoft jobsMuleSoft rates and salariesHire a senior MuleSoft developer