Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date insertion error
yousaf,
regarding the date error -- always use explicit date conversion (with the TO_DATE() function) when using string literals to populate oracle date columns. it is very possible that the session setting NLS_DATE_FORMAT will be different in different environments -- either because the DBA sets it differently in different databases or because some other code using the same session issues an ALTER SESSION statement to change it (this is especially a potential problem in web-based apps where sessions are re-used)
regarding the hanging -- not enough details to provide any assistance -- suggest you re-post with more details and a different subject
"Yousaf" <noway_at_hose.com> wrote in message
news:1069717430.885238_at_ananke.eclipse.net.uk...
| Thanks for the reply guys.
|
| The strange thing is that if I use 2001-2015 in the year, for example:
| '09-AUG-2015', oracle doesn't complain via ASP at all!!
|
| I really don't get it!
|
| Also another error which has suddenly appeared is that when I try to
update
| via ASP page, the browser hangs trying to connect to the server. Could
| anyone help on this one as well?
|
| Regards
|
|
| Yousaf
| Linux version 2.4.20-8
| gcc version 3.2.2
| Red Hat 9
Received on Tue Nov 25 2003 - 07:08:39 CST