From nmacdannald@sjdccd.cc.ca.us Wed, 04 Apr 2001 10:44:51 -0700 From: "Neil MacDannald" Date: Wed, 04 Apr 2001 10:44:51 -0700 Subject: PL/SQL - invail declare of char Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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: nmacdannald@sjdccd.cc.ca.usWeb Page: http://www.deltacollege.org/emp/nmacdannald