Path: news.f.de.plusline.net!news-fra1.dfn.de!news-stu1.dfn.de!news.germany.com!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wns14feed!worldnet.att.net!63.218.45.11!nx02.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail
Date: Sat, 03 Mar 2007 09:25:52 -0800
From: DA Morgan <damorgan@psoug.org>
Organization: Puget Sound Oracle Users Group
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Re: EXECUTE IMMEDIATE rounds up results
References: <1172940527.424176.63210@31g2000cwt.googlegroups.com>
In-Reply-To: <1172940527.424176.63210@31g2000cwt.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <1172942753.498202@bubbleator.drizzle.com>
Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)
Lines: 37
X-Complaints-To: abuse@csolutions.net
Xref: news.f.de.plusline.net comp.databases.oracle.misc:78432

ar123456@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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org