OTL 中的呼叫 存储函数 同事包含输出参数
我用 mssql
在头中定义了#define OTL_ODBC
我数据库中有一个存储函数
[dbo].[TestIt](@Id int,@howmany int output)
as
declare @TestTable Table
(ID int,testName int)
set nocount on
begin
insert into @TestTable
select TestID ,Num from test where TestID=@Id
select @howmany=count(ID) from @TestTable
select ID,testName from @TestTable
end
otl_nocommit_stream o.open(1,"{ call TestIt("
":A<int,in>,"
":B<int,out>"
")}",db );//otl_implicit_select
otl_nocommit_stream o.open(1,"{ call TestIt("
":A<int,in>,"
":B<int,out>"
")}",db ,otl_implicit_select);