Re: Stored Program Units in Oracle 7
Date: Thu, 07 May 1998 13:28:54 +0100
Message-ID: <6is5rp$3nu_at_news.Informatik.Uni-Oldenburg.DE>
Christophe wrote:
> Hello!
> I have a problem.
> I have to create some stored program units but i can't find how to declare
> parameters in help documentation on the Oracle 7 CR-ROM.
> Thanks for sending to me a sample at : lsa.perinfo_at_wanadoo.fr
After the IS and before the BEGIN
FUNCTION FUNK (the_char VARCHAR2) RETURN NUMBER IS
the_number NUMBER;
the_str VARCHAR2(100);
BEGIN
....
END;
Here you may also place procedures and functions belonging only
to the stored program unit:
FUNCTION FUNK (the_char VARCHAR2) RETURN NUMBER IS
the_number NUMBER;
the_str VARCHAR2(100);
PROCEDURE THE_PROC IS
the_number NUMBER(4,2);
BEGIN --THE_PROC
...
END; --THE_PROC
BEGIN --FUNK
....
END; --FUNK
Received on Thu May 07 1998 - 14:28:54 CEST