How to: Stored Procedure / Package

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; Received on Fri Jun 20 1997 - 00:00:00 CDT