Re: Function Call in PL/SQL script

Just be careful that you don't try to declare anything after your functions and procedures.

In your declare section, the following is illegal:

declare
  v_test1 number;

  procedure p_test is
  begin

      null;
  end;

  v_test2 number;

begin ----main-------------
  null;
end;

The following is OK:

declare
  v_test1 number;
  v_test2 number;

  procedure p_test is
  begin

      null;
  end;

begin ----main-------------
  null;
end;

--
Paul Dorsey
Dulcian, Inc.
www.dulcian.com
212 595 7223
A. el Azzouzi wrote in message <7j5blu$rkq$1_at_news.accu.uu.nl>...


>Hello there,


>

>Does anyone know if there is a possibility to define

>a function in a PL/SQL-script in order to call it many times

>in the same script.

>So, I don't mean stored procedures/packages.

>

>Many thanks in advance,

>

>A.

>

>

>

>