st 发帖数: 1685 | 1 plz help:
line.Format("{call %s.dbo.p_getVDKFilters (%d, %s, null, ?, ?)}",
m_sDatabase, m_instance, from_date);
the call is like
{call p_getVDKFilters (-1,null,null,@errcode,@errmsg)}
I can get output result from query analyzer, the similar
java program works... but this one does...
very simliar call to another store procedure can work...
the problem is one of the "null" is a datetime type for output parameter.
the other store procedure has nothing like this...
it outputed once, after a minor c | o***z 发帖数: 133 | 2 why can you use a null as output parameter?
【在 st 的大作中提到】 : plz help: : line.Format("{call %s.dbo.p_getVDKFilters (%d, %s, null, ?, ?)}", : m_sDatabase, m_instance, from_date); : the call is like : {call p_getVDKFilters (-1,null,null,@errcode,@errmsg)} : I can get output result from query analyzer, the similar : java program works... but this one does... : very simliar call to another store procedure can work... : the problem is one of the "null" is a datetime type for output parameter. : the other store procedure has nothing like this...
|
|