Re: "Sub Routine" Functionality Within Oracle

pmmgpgp_at_gmail.com schreef:

> Thanks guys, I may have been too general.
> The only way I know to declare a procedure requires the inclusion
> of a parameter or signature such as the "param" in
> "PROCEDURE my_proc(parar in varchar2) as ...." .
> This is how/why it is "declared". Is there a way not to include a

No - this is how the tool you use automagically creates it; it's up to you to decide whether you want this or not.

> parameter or signature ? If it is essential what makes Oracle recognize
> that it has been used ? I've tried things like some useless "if"
> statement
> ( if param = param then
> param = null;
> end if;) to no avail.
>
> One thought is that I use PL/SQL developer and this my relate to the
> tool and not PL/SQL at all . Any thoughts on rhis ?

PL/SQL Developer can do this, indeed. And it warns you for code never used (why would you want to write never-used code anyway? Seems a waste of time)

And if I were you, I'd read up on packages as well.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...