Hello,

> My problem is the following: I need to use SUBSTR function in a
> Stored Procedure already written inside the database (i.e. not by
> Dynamic SQL).
> Is it possible to call the DECLARE EXTERNAL FUNCTION from inside a
> Stored Procedure?
>
> I don't want to call this statement from the client or via isql.
>
> Is there a way to do this?

Using the SUBSTR function inside a Stored Procedure is
in no way connected to being able to use DECLARE
EXTERNAL FUNCTION in a Stored Procedure.

Once declared, you can use the function everywhere.

Perhaps you need to clarify what you want to do exactly.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com