Jacqui Caren wrote:

>Constantijn Wolfs wrote:
> > Hi,
> >
> > A trigger executes a stored procedure. One of the input parameters is of
> > type varchar.
> >
> > EXECUTE PROCEDURE CWS$GET_ID(NEW.ID, 'ENTITIES')
> > RETURNING VALUES NEW.ID
>
>If you use a temp var the error goes away?
>
>I know this is not a fix - only a workaround.
>
>Jacqui
>
>
>

No, I've tried that already. I've changed the character from
UNICODE_FSS to ASCII. And this error was gone. But I'm not sure that
this was the cause because along the way I made a few changes in other
sp's involved. Now I get a message length error with a
expected:encountered ratio of approx. 3. Looks like I'm messing things
up with UNICODE_FSS somewhere.