How to call a Stored Procedure with 'out' parameter

[eluser]fatman[/eluser]
Hi,

I have a procedure defined as :

Code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `int_MapColumnToCustomFields`(IN in_tableId SMALLINT , OUT out_ErrMsg VARCHAR(500))

1. How do i call it?

2. How do i get the out param?

I tried (I tried with mysql and mysqli):

Code:

$sql = "call int_MapColumnToCustomFields(?,?);";
        $params = array($id,'');
        $this->db->query($sql, $params);

But I got this error:

OUT or INOUT argument 2 for routine dortengine.int_MapColumnToCustomFields is not a variable or NEW pseudo-variable in BEFORE trigger

call int_MapColumnToCustomFields('1','');