adodbapi return value

[Nikolai Kirsebom]

I'm trying to use the adodbapi module, but run into the following
problem:

After initalization (connection, cursor) I have the following call to
a stored procedure (SQL Server, using SQLOLEDB.1 provider).

m = u'BrReg'
rs = u''
msg = u''
x = self.cur.callproc('__DocFetchBaseCategories', (0, 0, m, rs, msg))
print x
>>> [0, 0, u'BrReg', u'', u'']
print self.cur.returnValue
>>> None
print self.cur.rowcount
>>> -1

The procedure is enclosed below.  Strange thing is that if the
variable 'm' is set to an empty string, everything works ok, the
resultstate value (x[3]) becomes '_OK'.  However having the variable
'm' set to 'BrReg' as indicated, seems to result in the returned set
(x) not being updated.  When executing the Stored Procedure in Query
Analyzer, everything seems to be ok (BrReg is a valid value and
results in both '_OK' resultstate and a set of values (record set)).

When using the value m='', the returnValue when printed is 0.

---------------------------- FRAGMENT OF SQL CODE --------------------
create proc __DocFetchBaseCategories (
	@TraceLevel int, 
	@UserId int,
	@Module varchar(32),
	@Resultstate varchar(121) output,
	@Message varchar(255) output
) as
begin
	if @Module <> ''
	begin
		select 10000,
			C.Category,
			C.BaseCategory,
			C.CategoryDescription
		from _DerivedCategories D, _Categories C
		where D.Category like (@Module + '[_]%')
			and not D.BaseCategory like (@Module + '[_]%')
			and D.DerivedLevel = 1
			and D.Category = C.Category
	end
	else
	begin
		select 10000,
			Category,
			BaseCategory,
			CategoryDescription
		from _Categories
		where BaseCategory = ''
	end

	select @ResultState = '_OK',
		@Message = ''

NormalExit:

end

--------------------------------------------------------------------------------------------
The connection object reports 0 ADOerrors when I use the method
printADOerrors on the connection object.

Any help is appreciated.


Nikolai Kirsebom