Re: Stored Procedure Example Needed ??

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 12 Oct 1999 18:40:06 +0800
Message-ID: <38031006.6EC8@yahoo.com>

Ron Franks wrote:
>
> Can someone send me a simple example of a "Stored Procedure" please? I
> am on an Oracle 8.0.4 database.
>
> Thanks in advance.
>
> Ron.Franks_at_trw.com

create or replace
procedure modify_salary(p_empno number, p_new_salary number,

         p_audit boolean default true) is begin
  update salary_table
  set salary = p_new_salary
  where empno = p_empno;

  if p_audit then
    insert into audit_table

       ( p_empno||' salary was changed to '||p_new_salary);   end if;
end;
/
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Oct 12 1999 - 05:40:06 CDT