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 CHARIScalandarStringCHAR(10):= ' ';BEGIN SELECT term_desc || ' ' || to_char(start_date, '')intocalanderStringfromtermwhereterm = aterm2and academic_year= ayear4;RETURN (calanderString);EXCEPTIONWHEN OTHERS THENRETURN(calanderString);END;/ TIA! Neil MacDannald, Database AnalystSan Joaquin Delta College, Information ServicesVoice: (209)954-5300, Fax: (209)954-5302email: [EMAIL PROTECTED]Web Page: http://www.deltacollege.org/emp/nmacdannald
RE: PL/SQL - invail declare of char
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, '') 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).
Re: PL/SQL - invail declare of char
You didn't spell calanderstring consistently bi guy...(calendarstring...) [EMAIL PROTECTED] 04/04/01 02:41PM 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, '') 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] Web Page: http://www.deltacollege.org/emp/nmacdannald -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller 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).
RE: PL/SQL - invail declare of char
Neil, I bet you saw your spelling error the second you hit send. ;-) calendarString vs. calenderString Jack Jack C. ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin, Texaswww.iNetProfit.com[EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 CHARIScalandarStringCHAR(10):= ' ';BEGIN SELECT term_desc || ' ' || to_char(start_date, '')intocalanderStringfromtermwhereterm = aterm2and academic_year= ayear4;RETURN (calanderString);EXCEPTIONWHEN OTHERS THENRETURN(calanderString);END;/ TIA! Neil MacDannald, Database Analyst
RE: PL/SQL - invail declare of char
Easy one, Neil, you spelled calendar two different ways. (both of which are incorrect, not that it matters!) calandarString CHAR(10) := ' '; RETURN (calanderString); -Original Message- Sent: Wednesday, April 04, 2001 11:41 AM 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, '') 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 The information contained in this email is intended for the personal and confidential use of the addressee only. It may also be privileged information. If you are not the intended recipient then you are hereby notified that you have received this document in error and that any review, distribution or copying of this document is strictly prohibited. If you have received this communication in error, please notify Celltech Group immediately on: +44 (0)1753 534655, or email '[EMAIL PROTECTED]' Celltech Group plc 216 Bath Road, Slough, SL1 4EN, Berkshire, UK Registered Office as above. Registered in England No. 2159282 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maser, Donna (SEA) 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).