-
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
Vijay.s
-
Use uppercase letters in to_date, and provide some info about your "date_computed" function. What happens in there?
Oracle DBA and Developer
-
date_computed is a SIMPLE DATE FIELD in the TABLE ISS_TRAILCOMM..
Vijay.s
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|