|Subject||RE: [firebird-support] Re: Confusing behavior of UDF in stored procedure|
> > can you change your procedure to this:then I would rule out your code specifically by setting up a test of the
> > > CREATE PROCEDURE CreateStringId(val VARCHAR(32765))
> > > RETURNS (id CHAR(16))
> > > AS BEGIN
> > > SELECT varchar_to_guid(:val) FROM RDB$DATABASE INTO :ID;
> > > SUSPEND;
> > > END^
> > I have never used the syntax you have used here - not sure it's legal.
> > Alan
> Unfortunately this yields the same wrong result...
same three methods with a quite different UDF in the freeUDFLib.