RE: PL/SQL - invail declare of char

[Jack C. Applewhite]

Neil,   I bet you saw your spelling error the second you hit send.   ;-)   calendarString vs. calenderString   Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Neil MacDannald Sent: Wednesday, April 04, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: PL/SQL - invail declare of char 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