Hi We are facing a serious issue now in that our functionality no longer works for 11G customers as a result of the .extract being obsoleted for 11G.The .extract function is not obsoleted by noticed as being deprecated from 11.2 and onwards.
The bug itself has now been escalated and could result in P1 severity at any point.Its not a bug, on the contrary. Its a performance enhancement.
Is there a contact I could have from your team that I can liaise with directly to explain in detail the problems we are facing and to get some guidance on how to resolve?Of course you can, if you have a support contract via http://support.oracle.com. At any time you can put in a P1 or escalate your request to solve your problem.
Now, the problem is that conditional compilation is not enabled by default in version < 10.2, but it is available since 18.104.22.168.
CURSOR c_head IS $IF DBMS_DB_VERSION.VER_LE_10_2 $THEN SELECT header_xml.extract('/*').getClobVal() FROM je_oecd_audit_data_t ; $ELSE SELECT XMLSerialize(document header_xml as clob indent) FROM je_oecd_audit_data_t ; $END
We are facing issues with compilation of code in 22.214.171.124 - it doesn't like this:I guess you should also address to your customers, that 9.x and 10.1 database versions are NOT SUPPORTED by Oracle anymore (and also some of the 10.2.0.x versions for that matter). If you hit a bug then you will be out of luck regarding support.
Why would pretty printing via .extract still work for one customer on 126.96.36.199For the same reasons that Marco has listed above on this page. The function has been marked as Obsolete. That means Oracle is providing notice that at some point in the future, they could remove the function completely from the product. It means that the function still exists within the product and can be called and used just as it could in earlier versions. In version x.x.x.x far down the road, it may be removed and then any remaining third-party code (yours) that depended upon it would break. Until then, it will continue to work as it does today in future versions of Oracle, without any improvements from Oracle as they are putting those improvements into non-obsolete objects.