[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