Ok... this is driving me nuts!

From: Stefan Jakobsson <stefan_at_areldata.se>
Date: Wed, 13 Feb 2002 06:55:45 -0800
Message-ID: <F001.0040DE52.20020213062319@fatcity.com>

I have the following package defined....

PACKAGE RAKNAUPP AS
FUNCTION FAKTURANUMMER RETURN NUMBER;
FUNCTION MEDLEMSNUMMER RETURN NUMBER;
FUNCTION OCRNUMMER RETURN NUMBER;
FUNCTION INBETNUMMER RETURN NUMBER;
END RAKNAUPP; PACKAGE BODY RAKNAUPP AS
FUNCTION FAKTURANUMMER
RETURN NUMBER
IS NFAKNR NUMBER(8);
BEGIN

        SELECT medlfaktnr+1 INTO NFAKNR FROM parametrar FOR UPDATE;
        UPDATE parametrar SET medlfaktnr = medlfaktnr+1;
        COMMIT;
        RETURN (NFAKNR);

END FAKTURANUMMER;
FUNCTION OCRNUMMER
RETURN NUMBER
IS NOCRNR NUMBER(6);
BEGIN

        SELECT ocrnr+1 INTO NOCRNR FROM parametrar FOR UPDATE;
        UPDATE parametrar SET ocrnr = ocrnr+1;
        COMMIT;
        RETURN (NOCRNR);

END OCRNUMMER;
FUNCTION MEDLEMSNUMMER
RETURN NUMBER
IS NMEDNR NUMBER(6);
BEGIN

        SELECT medlnr+1 INTO NMEDNR FROM parametrar FOR UPDATE;
        UPDATE parametrar SET medlnr = medlnr+1;
        COMMIT;
        RETURN (NMEDNR);

END MEDLEMSNUMMER;
FUNCTION INBETNUMMER
RETURN NUMBER
IS NINBNR NUMBER(6);
BEGIN

        SELECT inbetnr+1 INTO NINBNR FROM parametrar FOR UPDATE;
        UPDATE parametrar SET inbetnr = inbetnr+1;
        COMMIT;
        RETURN (NINBNR);

END INBETNUMMER;
END RAKNAUPP; It works fine, except when I try to run it with call:

call RAKNAUPP.FAKTURANUMMER;

Then I get:

ORA-06576: not a valid function or procedure name call <ERROR>'raknaupp.fakturanummer'

And I'm about at my wits end here... I can't for my life figure out why this isn't working as it is suposed to!

Could someone please figure out what I am doing wrong?????????

Stefan Jakobsson
stefan.jakobsson_at_areldata.se
Telefon: 08-470 24 00
Telefax: 08-470 24 24
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Stefan Jakobsson
  INET: stefan_at_areldata.se

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). Received on Wed Feb 13 2002 - 08:55:45 CST