7453
社区成员
- 主页
调存储过程很急的呀
请问各位我用ORACLE写的存储过程但是我在VB中不知道怎样用呀请指教呀我现在很急的呀
我的存储过程如下呀
create or replace procedure count_num
(i_name in aaa.c_name%type,
i_count out number(4)
)
as
begin
select count(*) into i_count from aaa where c_name:=i_name;
end;
请指教怎样调用呀很急的呀
我的存储过程如下呀
create or replace procedure count_num
(i_name in aaa.c_name%type,
i_count out number(4)
)
as
begin
select count(*) into i_count from aaa where c_name:=i_name;
end;
请指教怎样调用呀很急的呀
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
online 2003-12-23
Dim cmd As ADODB.Command
Set cmd = New ADODB.Command
cmd.ActiveConnection = "DSN=test"
cmd.CommandTimeout = 180
cmd.CommandText = "sp_name"
cmd.CommandType = adCmdStoredProc
cmd.Execute , , adAsyncExecute'<--- start ASYNCHROUS
'You can also make a dumy progress bar to show proggres
Do While (cmd.State And adStateExecuting) = adStateExecuting
DoEvents
Loop
Set cmd = New ADODB.Command
cmd.ActiveConnection = "DSN=test"
cmd.CommandTimeout = 180
cmd.CommandText = "sp_name"
cmd.CommandType = adCmdStoredProc
cmd.Execute , , adAsyncExecute'<--- start ASYNCHROUS
'You can also make a dumy progress bar to show proggres
Do While (cmd.State And adStateExecuting) = adStateExecuting
DoEvents
Loop
knightknight 2003-12-23
to online(龙卷风(白学了,重新充电中)) 请问我的输入输出参数从哪里给传值呀，我现在真的很急呀
