-
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
-
while running a proc/func inside a package (public ones)
u have to run using packagename.procedurename(parameters)
if its function because it returns a value
do it like this in sqlplus
variable x datatype of returned value(size)
declare
:x := packagename.functionname(parameter);
end;
/
and then
to see what it has returned
print x
which will return the value.
hope this helps
-
Thanks for your help. Sorry for the delay, I have been out on vacation.
Amy
