Has anyone deployed firebird superserver using the merge modules? Have you
had to include functions from rfunc.dll or some other custom udf? I have
created an installer using the merge modules but placing rfunc.dll in the
UDF directory after installation does not seem to make the functions work
(specifically, ORD). I get this message:



"invalid request BLR at offset 101 function ORD is not defined"



I know the function is there because if I do a "show function ord" I get:



Function ORD:

Function library is rfunc

Entry point is fn_ord

Returns BY VALUE SMALLINT

Argument 1: CSTRING(1) CHARACTER SET NONE



If I install firebird using the standard firebird installer over my
installation, it works fine. This suggests that the problem is not in the
dll and it's not in the .fdb file, since those do not change when firebird
is installed. It seems to be either environmental or some configuration
thing.



Help please! I am trying to ship this to a customer before the end of the
week!

Thanks!



Aaron



-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Tuesday, May 03, 2005 2:03 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to get last error message in a procedure
2



At 05:30 AM 3/05/2005 +0000, you wrote:

>I thought that maybe some guys/girls who know the answer to my question
>below were at vacation when i first posted it, so here it comes
>again :)
>
> > Hi
> >
> > I want to catch any exception in a stored procedure, then concatenate
> > the error message with additional info and then raise exception with
> > more info. How to get error message of last exception?
>
>... is it possible at all?

It's *possible* with v.1.5, but would be quite a lot of work. It would
also be limited to 78 bytes ascii. (The length limit goes up to 1021
bytes in Fb 2).

In 1.5 you can get either the gdscode or the sqlcode as a context variable,
inside a handler that is in the scope of the code where the exception
occurred. You would need to create a table (sqlcode, gdscode,
text_of_message) in the database to look up the text of the message during
execution of your error handler.

./heLen




Visit http://firebird.sourceforge.net 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/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.



[Non-text portions of this message have been removed]