[freetds] Not getting return value and output parameter from storedprocedure.

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Oct 5 10:49:01 EDT 2007


> 
> Hi,
> 
> We are using FreeTDS 0.65 (TDS version 8.0) and unixODBC 
> 2.2.12 on RH Linux 3.4.6. We are connecting to Microsoft SQL 
> Server 2000 from Linux. I am using C++ on Linux. 
> 

Is ebay selling time machine ??
I didn't note we release 0.65 :)
Don't mind, just kidding... I think you are using a snapshot which
report 0.65.

> 
> 
> Requirement: To get return value and output parameter after 
> calling a stored procedure.
> 
> 
> 
> We are calling Stored Procedure (SP) with input and output 
> parameter and we are also expecting return value as well. 
> 
> 
> 
> We are calling stored procedure as follows:
> 
> 
> 
> {? = CALL stp_returnRow(?, ?, ?)}
> 
> 

MMmm... a unixODBC trace would help. We support this type of call so it
should works... what's the problem?? Aren't datas readed correct? Does
execute report an error/warning??

> 
> In above case we are expecting both return value and output 
> parameter. The first parameter is input and 2nd and 3rd 
> parameter is output parameter.
> 
> 

Remember that ODBC count also the result so you have 4 parameters.

> 
> We have written the above query to unixODBC and we were 
> informed that this problem is not in there Perview. This is 
> for your information.
> 
> 
> 
> Please suggest or give us solution if possible.
> 
> 
> 
> Thanks & best regards,
> 
> Rajesh Akolu
> 

bye
  freddy77


More information about the FreeTDS mailing list