Re: PL/SQL - invail declare of char

You didn't spell calanderstring consistently bi guy...(calendarstring...)

>>> nmacdannald_at_sjdccd.cc.ca.us 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: nmacdannald_at_sjdccd.cc.ca.us
Web Page: http://www.deltacollege.org/emp/nmacdannald

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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).