Hello.

I hope you can help me with what is probably such a simple problem. I am a Notes Developer who needs to create an Oracle stored procedure in order to export information back into Notes.

Now, my problem is, I have managed to create a package and a function, but now, HOW DO I RUN IT????? The Execute command gives me the error
PLS-00221: 'GETAANCOST' is not a procedure or is undefined
(This is the package)

or

PLS-00201: identifier 'GETTAXTOTAL' must be declared
(This is the function)

Here is the package:
CREATE OR REPLACE PACKAGE BODY GETAANCOST AS
FUNCTION GETTAXTOTAL(projectid NUMBER) RETURN NUMBER
IS
Taxtotal NUMBER(16);

BEGIN
SELECT taxtotal1 + taxtotal2 + taxtotal3 + taxtotal4 + taxtotal5
INTO TaxTotal
FROM detail
WHERE (project_id = projectid) AND (HWCheck = 'T');

RETURN (TaxTotal);
END GETTAXTOTAL;

END GETAANCOST;

/

Any help would be GREATLY appreciated!

Amy