Re: [unixODBC][Driver Manager]Function sequence error (SQL-HY010)

On Fri, 2 Mar 2012 16:43:39 -0500
"Bower, Wayne (Wayne)" <[email protected]> wrote:

> Essentially the issue appears to be related to using 'SET NOCOUNT ON'
> in a stored procedure. The script creates a procedure and executes
> it.  The cases that fail issue the message '[unixODBC][Driver Manager]
> Function sequence error (SQL-HY010)'.  To avoid the failure I have to
> either remove 'SET NOCOUNT ON' or move later in the procedure.  Keep
> in mind that this is just a test case to reveal the issue.  In our
> actual code we always start each procedure with 'SET NOCOUNT ON' and
> do much more than shown in this test case.

Is the problem restricted to procedures that pass parameters?  If not,
does bsqldb exhibit the same symptoms?  If so, could you provide just
the SQL?  

If parameters are required to provoke the problem, I would alter
src/odbc/unittests/rpc.c to induce it.  It tried the attached patch;
it did not alter the outcome of the test.  

HTH.  

--jkl

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds

Index: src/odbc/unittests/rpc.c
===================================================================
RCS file: /cvsroot/freetds/freetds/src/odbc/unittests/rpc.c,v
retrieving revision 1.15
diff -u -r1.15 rpc.c
--- src/odbc/unittests/rpc.c	12 Jul 2011 10:16:59 -0000	1.15
+++ src/odbc/unittests/rpc.c	3 Mar 2012 20:13:56 -0000
@@ -18,6 +18,7 @@
 			", @c varchar(20)\n"
 		"AS \n"
 		"BEGIN \n"
+			"SET NOCOUNT ON "
 			"select @null_input = max(convert(varchar(30), name)) from systypes \n"
 			"select @first_type = min(convert(varchar(30), name)) from systypes \n"
 			/* #1 empty result set: */