Tag Archives: PLSQL

How to invalidate pages in Webcache using database procedure

To invalidate dynamic pages in the webcache, you need send an XML file with the URL of the pages that you want to invalidate to web cache The advantage to use database procedure to invalidate is that should be invalidated as soon as the data in the database is updated. The better way is create […]

Error Messages ORA-19400 to ORA-24276

ORA-19400 to ORA-24276   ORA-19400: System type conflict with object SYS.string Cause: The user had an object with the same name as one of the system types. The system types were not initialized properly. Action: Remove the conflicting object and rerun migration. ORA-19500: device block size string is invalid Cause: the device block size returned […]

Error Messages ORA-00000 to ORA-00832

ORA-00000 to ORA-00832   ORA-00000: normal, successful completion Cause: Normal exit. Action: None. ORA-00001: unique constraint (string.string) violated Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level. Action: Either remove […]