EXECUTE IMMEDIATE rounds up results

1. I have a very simple stored procedure

PROCEDURE test_proc(
  invValue IN NUMBER,
  outValue OUT NUMBER)
IS
...

2. It works OK when called from another procedure.

3. However when called as dynmic sql, it rounds returned value to 2 decimals

  ...

   v_sql := 'BEGIN test_proc(:inValue, :outValue); END;'

   EXECUTE IMMEDIATE v_sql, using v_inValue, out v_outValue;

   v_outValue is always rounded to two decimal values, e.g. if real value is 187, it will be 190, if the real value is 123456, it will be 120000.

It is Oracle 9i and I could not find any information on the topic??????

Tnanks, Received on Sat Mar 03 2007 - 10:48:47 CST