How to call Stored Procedure in ASP.NET

[Igor Soukhov]

create or replace procedure GetSalary (empid in number)
is
begin
    select salary from employees where empid=empid;
end; 

You don't need the output param at all. Use

cmd.ExecuteScalar()

to get the result.

Thanks JetDeveloper. That looks like the proper solution for the stored procedure which designed to return one value.