Subject | incompatability - UDF |
---|---|
Author | rayholme |
Post date | 2005-03-02T22:30:58Z |
I have created UDFs for Interbase for years, then firebird 1.0.3
On the Linux (fedora) platform - two strange things happen.
1) if I declare the module_name as "SISudf"
the real library name must be libSISudf.so
before it was simply SISudf
also note that the names for fbudf.so and ib_udf.so do not have
"lib" in front
since I must use IB solaris - it would be nice for
compatablility if the module_name could be controlled (OK I can
macroize that in the ddl if required)
2) MORE serious - even with the new name (built the old way) I
cannot access the functions - I get:
Statement failed, SQLCODE = -104
invalid request BLR at offset 2
-function GET_BIT is not defined
-module name or entrypoint could not be found
- it found the module for sure as I renamed it till it did.
- the entry point should work - unless there are new ways to build
a UDF
Does anyone have an example makefile for building a 1.5 firebird UDF
file works on the Linux platform (fedora should make little
difference!)
If so, please send me an example of the makefile and any simple
function as you have it declared NOW. If you have a way to control the
names as request in #1 - I would love that too.
Thanks in advance.
Ray
On the Linux (fedora) platform - two strange things happen.
1) if I declare the module_name as "SISudf"
the real library name must be libSISudf.so
before it was simply SISudf
also note that the names for fbudf.so and ib_udf.so do not have
"lib" in front
since I must use IB solaris - it would be nice for
compatablility if the module_name could be controlled (OK I can
macroize that in the ddl if required)
2) MORE serious - even with the new name (built the old way) I
cannot access the functions - I get:
Statement failed, SQLCODE = -104
invalid request BLR at offset 2
-function GET_BIT is not defined
-module name or entrypoint could not be found
- it found the module for sure as I renamed it till it did.
- the entry point should work - unless there are new ways to build
a UDF
Does anyone have an example makefile for building a 1.5 firebird UDF
file works on the Linux platform (fedora should make little
difference!)
If so, please send me an example of the makefile and any simple
function as you have it declared NOW. If you have a way to control the
names as request in #1 - I would love that too.
Thanks in advance.
Ray