ar123456_at_gmail.com wrote:
> 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,
Post a working example that demonstrates the issue.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Mar 03 2007 - 11:25:52 CST
