|
View previous topic :: View next topic
|
| Author |
Message |
arunshan04
New User
.jpg)
Joined: 25 Apr 2009
Posts: 25
Location: chennai
|
|
|
|
hai what is the meaning for the sqlcode = 18}
this message i got wile opening the cursor inside my stored procedure ? |
|
| Back to top |
|
 |
saiprasadh
Active User
Joined: 20 Sep 2006
Posts: 154
Location: US
|
|
|
|
Hi Arun,
The SQL code is -180 . Can you post the query which is causing this SQL error.
| Quote: |
SQLCODE -180 SQLSTATE 22007
Bad data in Date/Time/Timestamp
String representation of DATE, TIME, TIMESTAMP is invalid |
Thanks
Sai |
|
| Back to top |
|
|
arunshan04
New User
Joined: 25 Apr 2009
Posts: 25
Location: chennai
|
|
|
|
sorry sai i am in out of office...
is that any meaning for the special simbol.. '}'? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
its the representation of a negative decimal zoned number
negative numbers
| Code: |
| x'd0d1d2d3d4d5d6d7d8d9' |
positive numbers
| Code: |
x'c0c1c2c3c4c5c6c7c8c9'
x'f0f1f2f3f4f5f6f7f8f9' |
|
|
| Back to top |
|
|
|
|
