Re: PL/SQL - invail declare of char

CalendarString's definition is spelled differently than in the instances where you are referencing it.  
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A title=nmacdannald_at_sjdccd.cc.ca.us href="mailto:nmacdannald_at_sjdccd.cc.ca.us">Neil MacDannald To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Wednesday, April 04, 2001 2:41
  PM
  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 AnalystSan Joaquin   Delta College, Information ServicesVoice: (209)954-5300, Fax:   (209)954-5302email: <A
  href="mailto:nmacdannald_at_sjdccd.cc.ca.us">nmacdannald_at_sjdccd.cc.ca.usWeb   Page: <A
  href="http://www.deltacollege.org/emp/nmacdannald">http://www.deltacollege.org/emp/nmacdannald Received on Wed Apr 04 2001 - 12:57:11 CDT