When executing a stored procedure that returns a decimal number output through the "Run" tab in the Editor, the number parameters is turned into integers in the Output column. For example if the Input field is 0.22 then after clicking on the Execute button the Output field shows 0 even though DBMS_OUTPUT.put_line still shows 0.22.
See screen shot SOL84606_Fig1.jpg.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center