| ORA-01722: invalid number [message #142924] |
Tue, 18 October 2005 07:43  |
vishnus
Messages: 7
Registered: October 2005
Location: India
|
Junior Member |
|
|
Hi,
The error "ORA-01722: invalid number" is recieved only for fewer files and many gets processed successfully.
This error is recieved while bulk collect.
I dynamically form Query and using execute immediate into Bulk collect data, during this an exception is thrown as invalid number.
I processed same file on my local server and it gets processed successfully.
I also checked NLS parameters by doing show parameter and on both production and local server are same.
Can any one suggest what could be the cause.
Thanks
|
|
|
|
|
|
| Re: ORA-01722: invalid number [message #143156 is a reply to message #142979] |
Wed, 19 October 2005 05:40  |
vishnus
Messages: 7
Registered: October 2005
Location: India
|
Junior Member |
|
|
Where clause is like
"WHERE STYPE = ''RFM'' AND HOME = 'US'
and TO_CHAR(DATE_OF,'DDMMYYYY')='12102005'
and ism=0"
one Column which I decode is like
DECODE(SIGN((DATE_OF + 5) - TRUNC(SYSDATE)) , -1,1,0)
|
|
|
|
|
|
|
|
| Re: ORA-01722: invalid number [message #143343 is a reply to message #143214] |
Thu, 20 October 2005 00:45 |
vishnus
Messages: 7
Registered: October 2005
Location: India
|
Junior Member |
|
|
hi,
Let me procide u exact query
WHERE STYPE = 'RFM' AND HOME = 'US'
and TO_CHAR(DATE_OF,'DDMMYYYY')='12102005'
and ism=0
stype varchar2
home varchar2
date_of date
ism number
This Query is a part of dynamic query.
Thanks
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
