Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Package PA_TASK_PUB1 procedure UPDATE_WBS_NUMBERS

Re: ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Package PA_TASK_PUB1 procedure UPDATE_WBS_NUMBERS

From: <fitzjarrell_at_cox.net>
Date: 12 Oct 2005 07:03:15 -0700
Message-ID: <1129125795.740580.244970@g43g2000cwa.googlegroups.com> 






ppong wrote:


> Help !

> The procedure to create a task version failed, no task version was

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

> conversion error in Package PA_TASK_PUB1 procedure UPDATE_WBS_NUMBERS

>  Looking forward for solutions.

> Thanks,

>

> ppong_at_lycos.com




Problem: You passed a non-numeric string to TO_NUMBER().



Solution: Stop doing that.




David Fitzjarrell
Received on Wed Oct 12 2005 - 09:03:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US