This content has been marked as final. Show 3 replies
Doesn't look like in OWB you can define these properties in functions within a package. If you want them in a package, as best you can do is create your package externally and use/reference in OWB.
If you create function outside of package and configure it as parallel deterministic and then CUT/PASTE it into package it will keep all of its properties as you can see when you generate code.
Thanks for the advice, the Cut & Copy idea from MccM is working fine, however is not really a solution for the problem. But we are using it as a workaround for the moment.
Just for documentation: There already exists a bugfix, addressing the issue of lost parrallel and deterministic information during an upgrade from OWB10.2 to 11.2 (see bug 14673399 and patch 16082939)
And for at least some of us with access to Oracle Support: Our onsite Oracle consultant opened a service request for this issue: 3-6773545351 (You will not be able to see the request unless You are an Oracle employee, but maybe the reference is helpful for You.)