Patrick,

> CREATE PROCEDURE SPROC RETURNS( TESTID NUMERIC(16,4)) AS

<...>

> The result is:
> OVERFLOW
>
> ??????
>
> am I missing anything ?

I am not familiar with the TIBO* stuff. But perhaps if you can post
the callstack from when this exception is raised it may help pin down
the problem.

Geoff Worboys
Telesis Computing