<cfstoredproc> tag doesn't work properly

[Imeshev]

Hi All,<br><br>I'm calling Centura SQLBase stored procedure via ODBC as<br><br><b>&lt;CFSET nExists = 0&gt;<br><br>&lt;CFSTOREDPROC PROCEDURE=&quot;inet_check&quot; DATASOURCE=&quot;LSRSII&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;CFPROCPARAM TYPE=&quot;IN&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CFSQLTYPE=&quot;CF_SQL_INTEGER&quot; VALUE=&quot;102&quot; NULL=&quot;NO&quot;&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;CFPROCPARAM TYPE=&quot;OUT&quot; SQLTYPE=&quot;CF_SQL_DOUBLE&quot;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VARIABLE=&quot;nExists&quot; NULL=&quot;NO&quot;&gt; <br>&lt;/CFSTOREDPROC&gt; <br></b><br><br>and ODBC returns S1000 error (general error), CF tells &quot;invalid parameter TYPE&quot;. Changing the OUT parameter to INOUT helps, but value isn't returned, and earlyer initialized nExists is getting blank instead having returned from sp value. <br><br>I'll be just grateful for any help. Moving all the logic from SPs wold real pain.<br><br>Slava