Please visit www.oracle-class.com for Videos, Free posts, Books, Webinar and Free forum … ALL about Oracle!

January 26, 2011

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

Filed under: 11 G,11G,administrador,barcelona — orawiss @ 2:17 pm

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

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: