Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DETERMINISTIC Function in Pkg
"userjohn" <userjohn_at_mailinator.com> a écrit dans le message de news: 13g7ipn104dlr11_at_corp.supernews.com...
| 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
|
|
This is not a private subprogram.
Yes.
Regards
Michel Cadot
Received on Wed Oct 03 2007 - 12:48:06 CDT