由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - ODBC call wont return output parameter and no err
相关主题
菜鸟求助: 用 Oracle Sqlldr Control File 能不能改character set?query analyzer VS. Stored procedure
再请教一个问题Informix中的trigger问题
Need help designing a table.Any faster way to retrieve only one record?
question on large tables (>=800 million records, 10 G bytes of data)Oracle Group and Index question
这个stored proc错在哪里?一个关于T-SQL的问题
How to convert this datetime in SQL Server?sql请教
select 跟 set 的区别?测一下你的t-sql 功力
如何决定index再请教大牛一个问题
相关话题的讨论汇总
话题: call话题: null话题: output话题: parameter
进入Database版参与讨论
1 (共1页)
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...

1 (共1页)
进入Database版参与讨论
相关主题
再请教大牛一个问题这个stored proc错在哪里?
Will you against CLR UDF?How to convert this datetime in SQL Server?
SSRS report failing to display dataset stringselect 跟 set 的区别?
转换成时间的格式 MS SQL如何决定index
菜鸟求助: 用 Oracle Sqlldr Control File 能不能改character set?query analyzer VS. Stored procedure
再请教一个问题Informix中的trigger问题
Need help designing a table.Any faster way to retrieve only one record?
question on large tables (>=800 million records, 10 G bytes of data)Oracle Group and Index question
相关话题的讨论汇总
话题: call话题: null话题: output话题: parameter