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