we have set nls_date_format to dd-mm- in parameter file .
but all the funtions which have some hard coded date value in the format of
dd-mm-
are giving not a valid month error
example is
create or replace function test_bkj(t_date date)
return varchar2
is
begin
if (t_date
Oracle DBA wrote:
we have set nls_date_format to dd-mm- in parameter file .
but all the funtions which have some hard coded date value in the format of
dd-mm-
are giving not a valid month error
example is
create or replace function test_bkj(t_date date)
return varchar2
is
Hmm, try to replace - if (t_date '12-12-2001')
with - if (t_date to_date('12-12-2001','dd-mm-'))
Jan Pruner
On Sat 5. January 2002 13:35, you wrote:
we have set nls_date_format to dd-mm- in parameter file .
but all the funtions which have some hard coded date value in the
Have a talk with your developers.
Implicit conversions of any kind should not be
allowed in production code. I think you know why, now.
Jared
On Saturday 05 January 2002 04:35, Oracle DBA wrote:
we have set nls_date_format to dd-mm- in parameter file .
but all the funtions which