Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: why ora1801
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 4 Topic 16846 of 17270
Post > Topic >>

Re: why ora1801

by haomiao <miaohaoz@[EMAIL PROTECTED] > Jul 4, 2008 at 05:16 PM

> The two systems could have different NLS_DATE_FORMAT ;
> ignoring the fact each piece mentioned above is unsup****ted.

the  NLS_DATE_FORMAT in both systems is same
   YYYYMMSSHH24MISS
both in unix enviroment and oracle session parameter.

If I change the tbl_txn_mon_t.sa_comm_date to 81, ora-1801
disappear. So ora1801 in my sco system should be result of
the wrong length of tbl_txn_mon_t.sa_comm_date.

Why oracle not re****t 1801, instead of "the sa_comm_date is too
short"?
And  why Aix not re****t 1801?
 




 4 Posts in Topic:
why ora1801
haomiao <miaohaoz@[EMA  2008-07-03 08:46:15 
Re: why ora1801
haomiao <miaohaoz@[EMA  2008-07-03 08:50:05 
Re: why ora1801
"Ana C. Dent" &  2008-07-04 15:09:29 
Re: why ora1801
haomiao <miaohaoz@[EMA  2008-07-04 17:16:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 17:44:40 CDT 2008.