困惑我已久的问题
谢谢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怎么办呢?
先谢了!
create or replace procedure proc_tmp(unit in int,bianhao in string)
is
begin
select ......
from .......
where unit='||unit||' and bianhao=''||bianhao||'';
end;
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;