Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "Sub Routine" Functionality Within Oracle
Frank van Bortel wrote:
> 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...
I couldn't beleive that it was so simple. Thank you all for your
undrstanding and assistance.
Dave
Received on Thu Nov 02 2006 - 14:45:09 CST