RE: PL/SQL - invail declare of char

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Wed, 04 Apr 2001 11:24:48 -0700
Message-ID: <F001.002E1875.20010404110218@fatcity.com>

<SPAN
class=453100318-04042001>Neil,
<SPAN
class=453100318-04042001> 
I bet
you saw your spelling error the second you hit send.   ;-)
<SPAN
class=453100318-04042001> 
<SPAN
class=453100318-04042001>calendarString<FONT color=#0000ff face=Arial size=2> vs.
calenderString
 
<SPAN
class=453100318-04042001>Jack

--------------------------------Jack C. 

ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Neil MacDannaldSent:   Wednesday, April 04, 2001 1:41 PMTo: Multiple recipients of list   ORACLE-LSubject: 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 Received on Wed Apr 04 2001 - 13:24:48 CDT