[freetds] ODBC: { ? = CALL myproc() }

Garrett Goebel garrett at scriptpro.com
Wed Apr 23 12:22:42 EDT 2003

From: Garrett Goebel [mailto:garrett at scriptpro.com]
> DBD::ODBC has a test case of odbc call syntax which calls a 
> procedure taking 1 integer input param  and returning
> output. If that test case is modified not to take an input
> var... it produces the same error as I show below.

Arghh... I missed another tiny? detail ;)

There is a success scenario for odbc call syntax against a parameter-less
stored procedure in the Perl/DBI/DBD::ODBC/WinNT/MDAC environment

For: CREATE procedure odbc_call as return 1

{?=call odbc_call()}   fails on WinNT w/ MDAC and DBD::ODBC

{?=call odbc_call}  succeeds on WinNT w/ MDAC and DBD::ODBC

Both cases result in the segfault on Linux/unixODBC/FreeTDS

Garrett Goebel
IS Development Specialist

ScriptPro                   Direct: 913.403.5261
5828 Reeds Road               Main: 913.384.1008
Mission, KS 66202              Fax: 913.384.2180
www.scriptpro.com          garrett at scriptpro dot com

More information about the FreeTDS mailing list