DETERMINISTIC Function in Pkg

10gR2 EE (10.2.0.3.0) /Solaris

According to the doc re. DETERMINISTIC Clause http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5009.htm#sthref6486

>> You cannot declare DETERMINISTIC a private subprogram (declared inside
>> another subprogram or inside a package body).

I have this in the BODY:

FUNCTION with_det_test(i IN NUMBER) RETURN NUMBER DETERMINISTIC
IS
BEGIN
       dbms_output.put_line(i);
RETURN i;
END; And in SPEC:

FUNCTION with_det_test(i IN NUMBER) RETURN NUMBER DETERMINISTIC ;

Why am I not getting compile error ?
so do I have a valid determ. function ?

thanks Received on Wed Oct 03 2007 - 12:01:19 CDT