Invalid Number [message #4434] |
Sun, 08 December 2002 20:46 |
Selvii
Messages: 2 Registered: November 2002
|
Junior Member |
|
|
Hi. This is my query in a procedure where I have declared
loan_bal as number;
Query:
SELECT nvl(sum(N_LOAN_BAL),0) INTO LOAN_BAL
FROM PSTM_LOAN_MASTER
WHERE C_CNTR_cODE = POLICY_NUMBER;
However, I keep getting the following mesg:
ORA-01722: invalid number
I have checked in the PSTM_LOAN_MASTER table to check the typd for N_LOAN_BAL, it's NUMBER(10,2).
Can someone help me with this mesg. Thanks in advance.
|
|
|
Re: Invalid Number [message #4435 is a reply to message #4434] |
Sun, 08 December 2002 22:56 |
Sanket Naik
Messages: 4 Registered: December 2002
|
Junior Member |
|
|
Check the variable you declared in your Pl/SQl (as word is not reqd) or declared the variable as
LOAN_BAL PSTM_LOAN_MASTER.N_LOAN_BAL%Type;
|
|
|