stored procedures help

[Anon]

How do you create a stored procedure or view in oracle 8?

[Anon]

pseudo syntax:

---

create or replace procedure_name (param var_type) AS
local_var vartype;
BEGIN
all_code_here;

END;

Obviously, you don't necessarily have to have any parameters or local variables, but that is where they go if you need them. HTH