FAQ
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_at_sjdccd.cc.ca.usWeb
Page: http://www.deltacollege.org/emp/nmacdannald" rel="nofollow">http://www.deltacollege.org/emp/nmacdannald">http://www.deltacollege.org/emp/nmacdannald

Search Discussions

  • Scott A. Brodsky at Apr 4, 2001 at 5:57 pm
    CalendarString's definition is spelled differently
    than in the instances where you are referencing it.


    Original Message -----
    From:
    Neil MacDannald
    To: Multiple recipients of list ORACLE-L

    Sent: Wednesday, April 04, 2001 2:41
    PM
    Subject: 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 AnalystSan Joaquin
    Delta College, Information ServicesVoice: (209)954-5300, Fax:
    (209)954-5302email: nmacdannald_at_sjdccd.cc.ca.usWeb
    Page: http://www.deltacollege.org/emp/nmacdannald" rel="nofollow">http://www.deltacollege.org/emp/nmacdannald">http://www.deltacollege.org/emp/nmacdannald
  • Bala, Prakash at Apr 4, 2001 at 6:10 pm
    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: nmacdannald_at_sjdccd.cc.ca.us
    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: prakash.bala_at_cingular.com

    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: ListGuru_at_fatcity.com (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).
  • Tim Sawmiller at Apr 4, 2001 at 6:13 pm
    You didn't spell calanderstring consistently bi guy...(calendarstring...)
    nmacdannald_at_sjdccd.cc.ca.us 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, '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: nmacdannald_at_sjdccd.cc.ca.us
    Web Page: http://www.deltacollege.org/emp/nmacdannald

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Sawmiller
    INET: sawmillert_at_state.mi.us

    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: ListGuru_at_fatcity.com (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).
  • Jack C. Applewhite at Apr 4, 2001 at 6:24 pm
    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.comjapplewhite_at_inetprofit.com

    -----Original Message-----From: 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
  • Maser, Donna (SEA) at Apr 4, 2001 at 6:28 pm
    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, '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: nmacdannald_at_sjdccd.cc.ca.us
    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 'is_at_celltech.co.uk'

    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: DonnaMaser_at_chiroscience.com

    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: ListGuru_at_fatcity.com (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).
  • Tim Sawmiller at Apr 4, 2001 at 6:39 pm
    I meant big guy....
    sawmillert_at_state.mi.us 04/04/01 02:56PM >>>
    You didn't spell calanderstring consistently bi guy...(calendarstring...)
    nmacdannald_at_sjdccd.cc.ca.us 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, '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: nmacdannald_at_sjdccd.cc.ca.us
    Web Page: http://www.deltacollege.org/emp/nmacdannald

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Sawmiller
    INET: sawmillert_at_state.mi.us

    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: ListGuru_at_fatcity.com (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).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Sawmiller
    INET: sawmillert_at_state.mi.us

    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: ListGuru_at_fatcity.com (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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 4, '01 at 5:44p
activeApr 4, '01 at 6:39p
posts7
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase