Subject Re: [firebird-support] PL/SQL vs nonexistent UDF
Author Thomas Steinmaurer
Josef,

> Is it possible do declare a stored procedure which would use a
> non-existent external function? That is, I can define an external
> function using:
>
> declare external function test
> returns integer
> entry_point 'TEST' module_name 'pepak.dll'
>
> This will succeed even if pepak.dll does not exist or does not export
> function TEST. That's OK as long as I do not attempt to call that function.
>
> Now I would like to create a stored procedure which would use that function:
>
> create procedure test
> returns ( a integer )
> as
> begin
> a = test();
> suspend;
> end
>
> But at this moment Firebird WILL check whether the function test exists
> in pepak.dll and return an error if it does not. Is there some way to
> suppress this error and create the procedure? I do not intend to use the
> procedure until the application makes sure a required version of
> pepak.dll is being used.

There is no way to do that, AFAIK.

You could reference another existing UDF with the same interface or have
some kind of stub UDF with at least the proper function exports.


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/