[unixODBC-dev] Getting "Return Values" from Stored Procedures

Don Oliver doliver at nxtv.com
Wed Sep 1 17:31:38 BST 2004


Thanks, freddy77,

I have worked around it by asking the Database developers
to always
return results as record sets. Only about 1% of the Stored Procedures were
returning a result using a RETURN VALUE.

Thanks again to everyone for their help.

Don


On Wed, 1 Sep 2004, ZIGLIO, Frediano, VF-IT wrote:

>
>
> >
> > Don Oliver wrote:
> > > Thanks Nick,
> > >
> > > I have tried putting that syntax into the commands, but it fails.
> > >
> > > I have only been able to successfully call stored procedures using
> > > this syntax :
> > >
> > > "exec procedure_name param1, param2, param3"
> > >
> > > which is the same syntax that works in the "isql" program that came
> > > with unixodbc.
> >
> > All isql does is pass it to the driver manager, and all that does is
> > pass it to the driver.
> >
> > I am guessing freetds doesn't support that syntax :-(
> >
> > I could suggest other non free drivers...
> >
>
> Syntax supported, use {?=call name(?)} or similar and
> SQLPrepare/SQLExecute
>
> freddy77
>
> _______________________________________________
> unixODBC-dev mailing list
> unixODBC-dev at mail.easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-dev
>



More information about the unixODBC-dev mailing list