Subject | Re: ISC Error 33554483 |
---|---|
Author | Marcos Lommez |
Post date | 2006-07-05T01:27:02Z |
Here is the DDL of the ROUND UDF
DECLARE EXTERNAL FUNCTION ROUND
DOUBLE PRECISION,
INTEGER
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'fn_round' MODULE_NAME 'rfunc';
i have removed the round function of my procedure and works fine.
But what is wrong with that udf?
DECLARE EXTERNAL FUNCTION ROUND
DOUBLE PRECISION,
INTEGER
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'fn_round' MODULE_NAME 'rfunc';
i have removed the round function of my procedure and works fine.
But what is wrong with that udf?
--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:
>
>
> > VALOR_OUT = ROUND(VALOR_OUT, 2); -- **** Here is the error. if
i
> > comment
> > this line every thing works fine
> > suspend;
> > end
> >
>
> What is this ROUND function you are using? It must be some UDF.
>
> Is it declared properly?
> Is it threadsafe?
> Have you made sure that VALOR_OUT is not null?
> Have you configured the UDF path in Firebird.conf?
> Have you restarted firebird since making any change to this path
>
> Are you able to use it in a simple query such as select ROUND(1.5,
1)
> from RDB$DATABASE; ?
>
> Adam
>