Niel,
You have declared CALAND'A'RSTRING. Change that from 'a' to 'e'.
Prakash
-----Original Message-----
Sent: Wednesday, April 04, 2001 2:41 PM
To: Multiple recipients of list ORACLE-L
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
San Joaquin Delta College, Information Services
Voice: (209)954-5300, Fax: (209)954-5302
email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Web Page: http://www.deltacollege.org/emp/nmacdannald
<http://www.deltacollege.org/emp/nmacdannald>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bala, Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
