It looks as if the parameters that are passed in to an Oracle stored procedure must be of the exact size that the data will be when passed back out from Oracle. I may be wrong but I am having some odd problems and think that this is related. If say an empty string variable is passed into an Oracle SP and this will also be an Output parameter, then the data passed back will be truncated. Does anyone know if this is the case? (and I am betting that "anyone" will be Mark <g>).

As always,
Thanks!
George