存储过程代码如下:
CREATE OR REPLACE PROCEDURE KEIT.sp_Ms_PhoneAuthCallbackEx
(
Called VARCHAR,
Calling VARCHAR,
Cause NUMBER,
Record NUMBER,
RegionCode VARCHAR,
CalledCallBack OUT NUMBER,
CallingCallBack OUT NUMBER,
CalledOutBoud OUT NUMBER
)
IS
PhoneType NUMBER;
Result NUMBER;
Hour NUMBER;
tmprecCount NUMBER;
BEGIN
tmprecCount := 0;
CallingCallBack := 2;
CalledCallBack := 0;
CalledOutBoud := 1;
END;
/调用代码如下:
int DB_AuthCallbackEx(char* pRegionCode, char *pCalled, char *pCalling, int nCause, int nRecord, int *pCalledCallBack, int *pCallingCallBack, int *pCalledOutBoud)
{
int Result = 0;
char * call_sql="begin sp_Ms_PhoneAuthCallbackEx("
":Called<char[21],in>,"
":Calling<char[21],in>,"
":Cause<int,in>,"
":Record<int,in>,"
":RegionCode<char[21],in>,"
":CalledCallBack<int,out>,"
":CallingCallBack<int,out>,"
":CalledOutBoud<int,out>);end;";
try
{
otl_stream o(strlen(call_sql), call_sql, db);
o << pCalled << pCalling << nCause << nRecord << pRegionCode;
o.set_commit(0);
o>>*pCalledCallBack;
o>>*pCallingCallBack;
o>>*pCalledOutBoud;
}
catch(otl_exception& p)
{
return -1;
}
return Result;
}执行之后根本不会输出,就是
o>>*pCalledCallBack;
o>>*pCallingCallBack;
o>>*pCalledOutBoud;
这三个东西执行了,结果没输出来,怎么回事???在线等!!!
CREATE OR REPLACE PROCEDURE KEIT.sp_Ms_PhoneAuthCallbackEx
(
Called VARCHAR,
Calling VARCHAR,
Cause NUMBER,
Record NUMBER,
RegionCode VARCHAR,
CalledCallBack OUT NUMBER,
CallingCallBack OUT NUMBER,
CalledOutBoud OUT NUMBER
)
IS
PhoneType NUMBER;
Result NUMBER;
Hour NUMBER;
tmprecCount NUMBER;
BEGIN
tmprecCount := 0;
CallingCallBack := 2;
CalledCallBack := 0;
CalledOutBoud := 1;
END;
/调用代码如下:
int DB_AuthCallbackEx(char* pRegionCode, char *pCalled, char *pCalling, int nCause, int nRecord, int *pCalledCallBack, int *pCallingCallBack, int *pCalledOutBoud)
{
int Result = 0;
char * call_sql="begin sp_Ms_PhoneAuthCallbackEx("
":Called<char[21],in>,"
":Calling<char[21],in>,"
":Cause<int,in>,"
":Record<int,in>,"
":RegionCode<char[21],in>,"
":CalledCallBack<int,out>,"
":CallingCallBack<int,out>,"
":CalledOutBoud<int,out>);end;";
try
{
otl_stream o(strlen(call_sql), call_sql, db);
o << pCalled << pCalling << nCause << nRecord << pRegionCode;
o.set_commit(0);
o>>*pCalledCallBack;
o>>*pCallingCallBack;
o>>*pCalledOutBoud;
}
catch(otl_exception& p)
{
return -1;
}
return Result;
}执行之后根本不会输出,就是
o>>*pCalledCallBack;
o>>*pCallingCallBack;
o>>*pCalledOutBoud;
这三个东西执行了,结果没输出来,怎么回事???在线等!!!
解决方案 »
- 求一个高效的sql
- 执行插入的存储过程问题
- 大表字段拆分与查询效率的问题
- 关于ORACLE的一个行类型控由制抬输入数据向表中插入数据的过程程序
- 发现表中有坏块,如何检索其它未坏的数据?以及如何查看某表上的约束?
- 急,打开Enterprise Manager console和Net configuration assistant报同样的错误(oran9.dll)
- oracle 怎么结束process进程
- 请问为什么2003下oracle的setup文件点击无响应?
- SQLSERVER中數據類型BIT 對應ORACLE10G是什麼?
- in子句问题
- 帖了一年都无人能解决的问题-wm_sys.wm_concat 排序问题
- 关于oracle中折分长字符串的问题
http://blog.vckbase.com/bruceteen/archive/2004/12/30/2373.aspx
你完全可以向OTL的maillist上提问或者发bug
http://otl.sourceforge.net/otl4_bug_report.htm