--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:

> At 01:57 AM 18/10/2003 +0000, you wrote:
> >I have some SQL like this:
> >
> >SELECT * FROM
> >MY_STORED_PROC(:INT_PARAM1, :STRING_PARAM, :INT_PARAM2)
> >
> >It executes correctly and returns the data I want, however, when I
> >move to the last record (or Delphi moves there in an attempt to
> >populate a grid) I get this error:
> >
> >Overflow occured during data type conversion
> >Conversion error from string "".
> >
> >What's would cause this? How can I prevent it?
>
> Are you using Firebird 1.5? If so, do you have OldParameterOrdering

set to

> True in firebird.conf?
>
> Also, could you show us the declaration of the output parameters in

the SP?

>
> Helen

The output paramters are:

SMALLINT,VARCHAR(20),SMALLINT and VARCHAR(24)