Negative Number problem

Hey all,

We are currently useing Oracle 7.3.2. Our developers are having a problem when calling a stored procedure. The are calling the procedure from a Delphi application. One of the parameters to the procedure is a number. What happens is that occasionally a positive number is passed in the parameter list and shows up as a negative number in the procedure. Here is a pseudocode version of what is happening:

call procedure_x(100, 'test')
.
.

Procedure_x(inum, istring)

   print inum --> Prints a seemingly random negative number

   rest of procedure code
End procedure

This problem is very sporadic. Sometimes it only happens on 1 client, sometimes on more than one at once.

Any help would be greatly appreciated.

Thanks,
Scott Dravet Received on Fri Dec 06 1996 - 00:00:00 CST