Re: PLEAsE PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From: Mahendra C <mahendrac_at_vsnl.com>
Date: Sun, 16 Dec 2001 16:58:17 +0530
Message-ID: <9vj36s$6s7$1@news.vsnl.net.in>

Try using TO_DATE instead of TO_CHAR That is try using

select students_per_enrolldate(TO_DATE('&ENROLL_DATE', 'DD-MON-YYYY')) from DUAL;

Regards
Mahendra

KDankwah <kdankwah_at_aol.comnojunk> wrote in message news:20011216014300.08402.00000469_at_mb-fg.aol.com...
> I have this function below and unfotunately when I test it I get the error
> message below what am I doing wrong. Could someone please tell me.
> =======================================================
> CREATE OR REPLACE FUNCTION Students_Per_Enrolldate
> (p_enroll_date IN ENROLLMENT.enroll_date%TYPE)
> RETURN STUDENT%ROWTYPE
> AS
> CURSOR c_student IS
> SELECT DISTINCT s.first_name , s.last_name, e.enroll_date
> FROM ENROLLMENT e, STUDENT s
> WHERE e.student_id = s.student_id
> AND e.enroll_date = p_enroll_date
> ORDER BY s.last_name, s.first_name, e.enroll_date;
> TYPE type_student_tab IS TABLE OF c_student%ROWTYPE
> INDEX BY BINARY_INTEGER;
> tab_student type_student_tab;
> BEGIN
> FOR l_student IN c_student
> LOOP
> tab_student(NVL(tab_student.last,0)+1):= l_student;
> END LOOP;
> DBMS_OUTPUT.PUT_LINE
> ('Enroll DATE Student Name');
> DBMS_OUTPUT.PUT_LINE
> ('====================================================');
> FOR e_enroll IN tab_student.first .. tab_student.last
> LOOP
> DBMS_OUTPUT.PUT_LINE
> ( tab_student(e_enroll).enroll_date||' '||
> tab_student(e_enroll).first_name || ' '||
> tab_student(e_enroll).last_name || ' ');
> END LOOP;
> END;
> /

>


> ================== TEST===========================

> 1 select students_per_enrolldate(TO_CHAR('&ENROLL_DATE', 'DD-MON-YYYY'))
> 2* From DUAL
> SQL> /
> Enter value for enroll_date: 30-JAN-1999
> select students_per_enrolldate(TO_CHAR('30-JAN-1999', 'DD-MON-YYYY'))
> *
> ERROR at line 1:
> ORA-00902: invalid datatype

>
>

> Thanks a lot
Received on Sun Dec 16 2001 - 05:28:17 CST