Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> PL/SQL - invail declare of char

PL/SQL - invail declare of char

From: Neil MacDannald <nmacdannald_at_sjdccd.cc.ca.us>
Date: Wed, 04 Apr 2001 10:44:51 -0700
Message-ID: <F001.002E176F.20010404104110@fatcity.com>

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:44:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US