Path: news.f.de.plusline.net!news-fra1.dfn.de!news-stu1.dfn.de!news.germany.com!postnews.google.com!31g2000cwt.googlegroups.com!not-for-mail
From: ar123456@gmail.com
Newsgroups: comp.databases.oracle.misc
Subject: EXECUTE IMMEDIATE rounds up results
Date: 3 Mar 2007 08:48:47 -0800
Organization: http://groups.google.com
Lines: 28
Message-ID: <1172940527.424176.63210@31g2000cwt.googlegroups.com>
NNTP-Posting-Host: 71.10.245.33
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1172940538 20875 127.0.0.1 (3 Mar 2007 16:48:58 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 3 Mar 2007 16:48:58 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.1.2) Gecko/20070219 Firefox/2.0.0.2,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 31g2000cwt.googlegroups.com; posting-host=71.10.245.33;
   posting-account=XOfBjw0AAACEk3Zyth1LXWPeRRSmfiDD
Xref: news.f.de.plusline.net comp.databases.oracle.misc:78431

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,