>> 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.
Thanks. For now I am using EXECUTE STATEMENT to overcome the problem. It works fine in my particular case, though if there was a solution which didn't require EXECUTE STATEMENT, I would happily switch to it. Pepak ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
