| Author |
Message
|
| srikanth av |
 Posted: Mon Mar 06, 2006 7:11 am Post subject: Database Updation error |
 |
|
Apprentice
Joined: 30 Jun 2005
Posts: 37
|
Hi,
i constructed an SQL query in Compute node for updating the database and using PASSTHRU statement i am executing it in the Oracle database,but i ended up with an error saying...
ORA-01858: a non-numeric character was found where a numeric was expected
But the same query when i executed through Oracle SQL* PLUS,it got executed successfully.
Can any one help me in this regard...
Thanks in advance.
_________________
a v srikanth |
|
| Back to top |
|
 |
| wschutz |
| Posted: Mon Mar 06, 2006 7:21 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
is the field you're passing a character field and did you CAST it to a numeric type?
_________________
-wayne |
|
| Back to top |
|
|
| srikanth av |
| Posted: Mon Mar 06, 2006 8:02 am Post subject: |
|
|
Apprentice
Joined: 30 Jun 2005
Posts: 37
|
is the field you're passing a character field and did you CAST it to a numeric type?
I have constructed the SQL query with many fields which contains both character fields and numeric fields.
Actually i have constructed the query dynamically from the input message and the results of another query.
When i updated the same table with another message it is working.But it is giving errors for some queries which are executing successfully in SQL * PLUS.
_________________
a v srikanth |
|
| Back to top |
|
|
| vk |
| Posted: Mon Mar 06, 2006 9:09 am Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
Can you post the query and the table structure?
Regards,
VK. |
|
| Back to top |
|
|
| srikanth av |
| Posted: Mon Mar 06, 2006 10:55 am Post subject: |
|
|
Apprentice
Joined: 30 Jun 2005
Posts: 37
|
Hi Everyone,
I got the solution.I have used to_date function of Oracle and appended this function to DATE string and passed to database using PASSTHRU statement in esql.
Thank you for your responses.
_________________
a v srikanth |
|
| Back to top |
|
|
|
|
