Hi I am using the below version...

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production


When i fire this particular block i am getting the below error...the date computed field is an DATE FIELD..

1 declare
2 cursor s1(c_passdate date) is
3 select
4 'x'
5 from
6 iss_trailcomm
7 where
8 date_computed <= to_date('21/11/2001','dd/mm/yyyy');
9 begin
10 null;
11* end;
SQL> /
date_computed <= to_date('21/11/2001','dd/mm/yyyy');
*
ERROR at line 8:
ORA-06550: line 8, column 18:
PLS-00222: no function with name 'TO_DATE' exists in this scope
ORA-06550: line 3, column 1:
PL/SQL: SQL Statement ignored