I want to call a function previously created from a stored procedure.

I thought it would just be
declare X integer;
Set X = fnGetNextID ().

But that does not compile in the stored procedure.

Jim

Jim,

<< I want to call a function previously created from a stored procedure.

I thought it would just be
declare X integer;
Set X = fnGetNextID ().

But that does not compile in the stored procedure. >>

Functions and procedures are a special beast - they cannot be created in a
procedure in which they are called later.  They have to exist before the
procedure can be compiled.

--
Tim Young
Elevate Software
www.elevatesoft.com