困惑我已久的问题

谢谢yzf01 和 sgq_hit,但是。。。
我在SqlServer中有个过程如:
CREATE PROCEDURE proc_tmp(@unit int,@bianhao char(4))
AS

select rectime,badai*100 as badai
from tsum_his_alarm
where unit=@unit and bianhao=@bianhao
这样我可以在C++Builder 中直接调用这个存储过程,
但ORACLE怎么办呢?
先谢了!
[304 byte] By [glmcglmc-joe] at [2007-12-16]
# 1
create or replace procedure proc_tmp(unit in int,bianhao in string)
is

begin
select ......
from .......
where unit='||unit||' and bianhao=''||bianhao||'';

end;
jiezhi-风满袖 at 2007-10-23 > top of Msdn China Tech,Oracle,基础和管理...
# 2
create or replace procedure proc_tmp
(pi_unit in integer,pv_bianhao in varchar2)
is
begin
..........
select ......
from .......
where unit=pi_unit and bianhao=pv_bianhao;
..........
end;
jlandzpa-jlandzpa at 2007-10-23 > top of Msdn China Tech,Oracle,基础和管理...
# 3
不应该呀,Oracle的存储过程不能返回数据集呀
liujinzhou-天苍苍 at 2007-10-23 > top of Msdn China Tech,Oracle,基础和管理...