C#里面运用Oracle 存储过程笔记

C#中使用Oracle 存储过程笔记

1.         调用包含out/ in out类型参数的存储过程

存储过程:

CREATE OR REPLACE PROCEDURE "S99vE_ED99vS99vEDATAEXIST"  

 (id_ number,

name_ varchar2,

httpRoot_ varchar2,

flag out integer )//out 只具备输出功能 in out 为输入/输出型

as

tempNum integer;

begin 

    flag:=0;

    select count(id) into tempNum  from WebSite_Info where Name = name_ and ID<>id_;

    if tempNum > 0 then  

        flag:=3;   

    end if;

    select count(id) into tempNum  from WebSite_Info where HttpRoot = HttpRoot_ and ID<>id_;

    if tempNum > 0 then  

        flag:=4;   

    end if; 

[1] [2] [3] [4] 下一页