PLS-00231: Function "calculate_1" may not be used in SQL

Hello,

I try to create a packaged set returning function. When trying to compile the package header, I get the PLS-00231 error.

I've anonymized the source because of confidentiallity. The relevant source of the package header is as follows:

create or replace
PACKAGE test_1 AS

• Returns value3 if criteria match, else 0.0 FUNCTION calculate_1(value1 IN CHAR(5 CHAR), value2 IN CHAR(5 CHAR), value3 IN NUMBER) RETURN NUMBER;
• Cursor doing the calculations CURSOR test_cursor (datum IN DATE) IS SELECT [cut] SUM(caculate_1(value1, value2, value3)) "header" FROM [else cut];

END test_1;

The function calculate_1 simply does some comparisons. If these match, then it returns value3, else 0.0

When I try to compile this package header, then Oracle gives my an error PLS-00231
It's not clear to me, why I cant use this function in the sql, since the database is not altered in it.
Do I have to use some pragma instructions?

OS: W2K
Oracle 10gR2

With kind regards

Florian Reiser

-- 
http://www.ra-bc.de
RA Unternehmensberatung
Führen durch präzise Daten