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)
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
SELECT taxtotal1 + taxtotal2 + taxtotal3 + taxtotal4 + taxtotal5
WHERE (project_id = projectid) AND (HWCheck = 'T');
Any help would be GREATLY appreciated!
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)
:x := packagename.functionname(parameter);
to see what it has returned
which will return the value.
hope this helps
Thanks for your help. Sorry for the delay, I have been out on vacation.
Click Here to Expand Forum to Full Width