How to?: Stored Procedure

Hello,

At this time I have a series of four update queries that I kick off from the command scheduler in NT. I'd like to put them in a stored procedure or package. What syntax do I use to create the procedure package?

Something like this????????

Create or replace procedure EP_PRO

	UPDATE INTO ...
	WHERE ...;

	UPDATE INTO ...
	WHERE ...;

	UPDATE INTO ...
	WHERE ...;

End EP_PRO;

• Larry Schenavar lorenzo_at_gate.net