You may have encountered an error indicating that the Oracle trigger is invalid and the revalidation failed. Coincidentally, there are a number of steps you can take to resolve this issue, which we will now discuss. medic89 Posts: 14 Signed: Monday 05 September 10:44 2016…
You may have encountered an error indicating a dbms_output buffer overflow. There are several ways to solve this problem, and we’ll discuss them shortly. g.The standard buffer size should be 20,000 bytes. The minimum size is 2003 bytes, and the maximum size is virtually…
If you haven’t seen the SQL error ora-00979, grouping by expression, this guide should help. g.ORA-00979 “Not some GROUP BY expression” is an error returned by an Oracle collection when a SELECT statement contains a primary column that is not listed as the last…
