Re: Creating several functions in the same script

You can do this.
After the END;, put a / between each create or replace function statement. If you get errors, do a show error. If you are going to log the output, turn document on and echo on and spool it to a file.

<miguelangel6886_at_my-deja.com> wrote in message news:9136vj$mpr$1_at_nnrp1.deja.com...
> Is it possible to create several functions in the same sql script?
> I write
> CREATE O REPLACE FUNCTION A(param1) RETURN number
> IS
> -- variables
> ...
> BEGIN
> -- function body
> ...
> END;
> CREATE O REPLACE FUNCTION B(param1) RETURN number
> IS
> -- variables
> ...
> BEGIN
> -- function body
> ...
> END;
>
> Then I get an error (compiled with errors. Any clue?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 11 2000 - 13:32:44 CST