# Parameters not passed while calling a remote stored procedure \[Dreamfactory v2.12\]

**URL:** <https://community.dreamfactory.com/t/parameters-not-passed-while-calling-a-remote-stored-procedure-dreamfactory-v2-12/4349>\
**Category:** Connecting to SQL\
**Tags:** rest\
**Created:** [March 23, 2018, 3:07pm UTC](https://community.dreamfactory.com/t/parameters-not-passed-while-calling-a-remote-stored-procedure-dreamfactory-v2-12/4349 "2018-03-23T15:07:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![schlivo](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@schlivo](https://community.dreamfactory.com/u/schlivo)\
**Post date:** [March 23, 2018, 3:07pm UTC](https://community.dreamfactory.com/t/parameters-not-passed-while-calling-a-remote-stored-procedure-dreamfactory-v2-12/4349/1 "2018-03-23T15:07:39Z")

</div>

My environement info:  
_License Level: OPEN SOURCE_  
_DreamFactory Version: 2.12.0_  
_System Database: mysql_  
_Install Path: /opt/dreamfactory/_  
_Log Path: /opt/dreamfactory/storage/logs/_  
_Log Mode: single_  
_Log Level: DEBUG_  
_Cache Driver: file_  
_Cache Path: /opt/dreamfactory/storage/framework/cache/data/_  
_Demo: false_

I’m trying to call a remote stored procedure this stored procedure with a single parameter

_CREATE DEFINER=`dba`@`%` PROCEDURE `sp_my_proc`(_  
\_ IN `param` varchar(11)\_

_)_  
_LANGUAGE SQL_  
_NOT DETERMINISTIC_  
_CONTAINS SQL_  
_SQL SECURITY DEFINER_  
_COMMENT ‘’_  
_SELECT param_

When I try to call the procedure in API\_Docs with this request:

curl -X GET “[http://xx.xx.xx.xx/api/v2/data\_dev\_us/\_proc/sp\_my\_proc?param=1](http://xx.xx.xx.xx/api/v2/data_dev_us/_proc/sp_my_proc?param=1)” -H “accept: application/json” -H “X-DreamFactory-API-Key:…”  
the response return an error:  
_“Failed to call database stored procedure.\nSQLSTATE[42S22]: Column not found: 1054 Unknown column ‘param’ in ‘field list’”,_

My educated guess is that the framework doesn’t pass any parameter to the remote procedure.  
As I get the same SQL Error message if I run this command in mysql client : call sp\_my\_proc();

Update: MariaDB host is a columnstore configured instance. I confirm that for standard MariaDB instance, the issue is not present.

Regards,

Dejan