It will be interesting to see how the new Metalink
(touted for mid this year at UKOUG) performs...It has
a look-and-feel akin to most of its new Portal based
sites (eg AskTom).
Cheers
Connor
--- Jeremiah Wilton [EMAIL PROTECTED] wrote:
On Thu, 3 Jan 2002, [EMAIL PROTECTED]
wrote:
Why do
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
--- Jeremiah Wilton [EMAIL PROTECTED] wrote:
If you perform graceful failover, A.K.A. role reversal, you can have
the former primary pick up as the standby immediately after failover
without recopying. I cover this topic in my Openworld paper on my
site.
the problem is, you usually
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
12333 it is often related with communications problems
and resetting of them. Seldom related with parsing of
creation of objects. In the case of network problem
check the NLS and ask users if there are receiving
sporadically TNS errors.
Check also if there are some 4031. Maybe the reason it
is
Actually, even something like Hp's ServiceGuard is not so
graceful, depending on the app using the database. I have
had a database fail and know one know and a different
database fail and everyone know. You really have to take into
account with the app that it might lose connection. You need
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
You can create a LOGON Trigger to stop users using anything i.e. SQLPLUS
,MSACCESS etc...
I have applied one at our site and works good. I even log people who try to
log in and get them to explain to management their motives. That is a good
deterrent.
The trigger can be written so that only