Enterprise Computing
Tuesday, November 15, 2005
  Simple Oracle Stored Procedure Example

CREATE OR REPLACE PROCEDURE "SA"."UPDATE_FUND_SHORT_NAME"
(in_fund_id IN number, in_new_short_name IN varchar2)
AS
BEGIN
UPDATE FUND
SET SHORT_NAME = in_new_short_name
WHERE FUND_ID = in_fund_id;
commit;
END;

 




<< Home
Alistair Thomas's 'everything to do with enterprise computing'.

Archives
03/01/2004 - 04/01/2004 / 04/01/2004 - 05/01/2004 / 05/01/2004 - 06/01/2004 / 08/01/2004 - 09/01/2004 / 03/01/2005 - 04/01/2005 / 04/01/2005 - 05/01/2005 / 06/01/2005 - 07/01/2005 / 08/01/2005 - 09/01/2005 / 09/01/2005 - 10/01/2005 / 11/01/2005 - 12/01/2005 / 02/01/2010 - 03/01/2010 / 06/01/2013 - 07/01/2013 /


Powered by Blogger

Subscribe to
Posts [Atom]