How to fix EXCEPTION in chrow processing – code: -14551 msg: ORA-14551: cannot perform a DML operation inside a query in 11.2.0.1 version

Post available in my Website: www.oracle-class.com
1- Introduction:

From 10g of Oracle, the “dbms_space.object_growth_trend” is a new useful pipelined function that displays the segment growth at a specific point in time. The statistics are collected from the Automatic Workload Repository Facilities (AWRF) every day.

The column QUALITY has 3 different values: “GOOD”, “INTERPOLATED”, “PROJECTION”.

– The “GOOD” value indicates that the space allocated and usage figures are accurate for that day.

– The “PROJECTED” value indicates that the space calculations are projected from the data collected by the AWR facility, not collected directly from the segment.

– The “INTERPOLATED” value indicates that the value was not really collected or projected from the AWR facility.

more details can be found in the : Oracle documentation

2- Environment test details:

First, I create a simple table. Then, I inserted few rows. (See below)

3- The error:
I got the error “EXCEPTION in chrow processing – code: -14551 msg: ORA-14551: cannot perform a DML operation inside a query” when calling the “dbms_space.object_growth_trend” pipelined function.

4- The Fix:
To simple fix the error, you can turn off the server output option from sql plus.

To download the sql script, click here!

Thank you very much,
Nice reading
Wissem EL KHLIFI
http://www.oracle-class.com