pragma, restricted_reference and a union

From: Peter de Wolff <p.c.de.wolff_at_nospam.pve.agro.nl>
Date: Thu, 14 May 1998 17:42:25 +0200
Message-ID: <vwZk0B$E0Jxw@ns2>

Hi,

I'think i have got an nice problem, maybe you can help me out.

There is a package (HEFEXACT) which has a function called EXACT_REGEL_NR. This function is declared with a pragma restricted_reference with the option WNDS (and not WNPS).

When i use this function in a single select like SELECT HEFEXACT.EXACT_REGEL_NR,COLUMN,COLUMN FROM MYTABLE; eveyrthing goes right.

When i do a select like
SELECT HEFEXACT.EXACT_REGEL_NR,COLUMN,COLUMN FROM MYTABLE UNION
SELECT HEFEXACT.EXACT_REGEL_NR,COLUMN,COLUMN FROM MYTABLE2; i get an error ora-06573,.

Oracle message:
ORA-06573 function name modifies package state, cannot be used here

What is causing this?

Environment: Oracle 7.1.5.2.3 on OPENVMS 6.2 on a Alpha server

Thanks in advance Received on Thu May 14 1998 - 10:42:25 CDT