error that i get in Oracle 11.2

Question

1.0.6 my program works excellent but in Oracle 11.2 i get error ORA-01830

what can be the problem ? is there any Difference between 11.1 and 11.2 ?

thanks in advance

Here is the New Features Guide that describes the main differences: http://download.oracle.com/docs/cd/E11882_01/server.112/e17128/chapter1.htm — Peter G., Mar 01 '11 at 13:29
For the bugfixes in 11.2.0.2 you can look at My Oracle Support "11.2.0.2 Patch Set - List of Bug Fixes by Problem Type [ID 1179583.1]" if you have access. — Peter G., Mar 01 '11 at 13:32

score 3 · Answer 1 · answered Mar 01 '11 at 13:31

3

The error is:

ORA-01830: date format picture ends before converting entire input string

So it could be cause by different default date format masks (NLS_DATE_FORMAT parameter) in the 2 environments.

answered Mar 01 '11 at 13:31

Tony Andrews

129,880
21
220
259

score 3 · Accepted Answer · answered Mar 01 '11 at 13:31

There is a parameter called NLS_DATE_FORMAT, which defines how your dates are converted to characters as default. You are probably treating a string as date, and Oracle tries to automatically convert it to date but fails. You may want to set that parameter to the one you used in 11.1;

ALTER SYSTEM SET NLS_DATE_FORMAT='<Your Date Format In 11.1 Here>';

error that i get in Oracle 11.2

2 Answers2