You didn't spell calanderstring consistently bi guy...(calendarstring...)
>>> [EMAIL PROTECTED] 04/04/01 02:41PM >>>
Hello,
I know I am missing something. I just can't see it right now. Could someone please
tell me what is wrong here? We use version 8.1.6 on Spar Solaris 7.
I am getting the following error when I try to create this function as sys.
PLS-00201: identifier 'CALANDERSTRING' must be declared
Here is the function.
CREATE OR REPLACE FUNCTION ACADEMICYEARTERM_TO_CAL(
ayear4 IN CHAR,
aterm2 IN CHAR)
RETURN CHAR IS
calandarString CHAR(10) := ' ';
BEGIN
SELECT term_desc || ' ' || to_char(start_date, 'YYYY')
into calanderString
from term
where term = aterm2
and academic_year = ayear4;
RETURN (calanderString);
EXCEPTION
WHEN OTHERS THEN
RETURN(calanderString);
END;
/
TIA!
Neil MacDannald, Database Analyst
San Joaquin Delta College, Information Services
Voice: (209)954-5300, Fax: (209)954-5302
email: [EMAIL PROTECTED]
Web Page: http://www.deltacollege.org/emp/nmacdannald
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).