ORA-06502: PL/SQL: numeric or value error: character to number

From: sh.476622 sh476622 <sh476622_at_my-deja.com>
Date: Mon, 14 May 2001 09:10:38 +0000 (UTC)
Message-ID: <200105140910.CAA32033@mail23.bigmailbox.com>

('binary' encoding is not supported, stored as-is)

The following statements works fine in Oracle 8.0.5 and fails in 8.1.7.

What can be the reason ?

Regards,
Rene

Example 1

---

declare

t_getal     number(8);
t_line     varchar2(8);

begin
t_getal      := 333;
t_line       := lpad(t_getal,8,'0');    -- hier zou uit moeten komen de

string: 00000333

Sqlerrm: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Example 2

---

t_line     := '   ';
t_getal      := nvl(to_number(t_line),0);     -- hier zou uit

moeten komen het getal 0

PL/SQL: numeric or value error: character to number conversion error

---

--== Sent via Deja.com ==--
http://www.deja.com/

-- 
Posted from [212.189.163.122] by way of mail23.bigmailbox.com [209.132.220.203] 
via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Mon May 14 2001 - 04:10:38 CDT