you dont have to use TO_DATE function
you can=20
select next_date into d_date from .....
if the d_date is date variable
Ivo Libal
> -----Urspr=FCngliche Nachricht-----
> Von: prem_at_ibsplc.com [SMTP:prem_at_ibsplc.com]
> Gesendet am: Freitag, 7. Juli 2000 08:34
> An: Multiple recipients of list ORACLE-L
> Betreff: Problem while scheduling Jobs
>=20
> Hi,
> This is the same problem that I had posted once. I have scheduled =
a
> job, inside the function that is scheduled, there is a select =
statement
> like this
>=20
>=20
> select to_date(next_date,'DD-MM-YYYY') into d_date from dual where =
job =3D
> '1000';
>=20
>=20
> This particular statement causes an exception and writes this to the =
alert
> file in the Bdump. It says Non numeric character was found where =
expected.
> This caused the alert log to get filled up and Oracle server crashes. =
I am
> using Oracle version 8.0.4. If it is a problem with the date format, =
how
> can it be rectified.
>=20
>=20
>=20
> Can anybody please explain why this happens?
>=20
>=20
> It would be of a great help.
>=20
>=20
> Thanks in advance.
>=20
>=20
> --=20
> Author:=20
> INET: prem_at_ibsplc.com
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jul 07 2000 - 04:39:19 CDT
