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.
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center