Hi All,<br><br>I'm calling Centura SQLBase stored procedure via ODBC as<br><br><b><CFSET nExists = 0><br><br><CFSTOREDPROC PROCEDURE="inet_check" DATASOURCE="LSRSII"<br> <CFPROCPARAM TYPE="IN"<br> CFSQLTYPE="CF_SQL_INTEGER" VALUE="102" NULL="NO"><br> <CFPROCPARAM TYPE="OUT" SQLTYPE="CF_SQL_DOUBLE"<br> VARIABLE="nExists" NULL="NO"> <br></CFSTOREDPROC> <br></b><br><br>and ODBC returns S1000 error (general error), CF tells "invalid parameter TYPE". 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