I got that error when I tried to execute this query:
select * from lc_history2 lc where lc.view_name <> 'LC Main' and lc.modifiedtime = (select max(modifiedtime) from lc_history2 l where lc.lc = l.lc) and lc.modifiedtime >= sysdate-30
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
ORU-10027 will appear if you are using a lot of
dbms_output.put_line in your
PL/SQL with a small buffer amount. If you are just debugging then you should set this to a large amount (
dbms_output.enable(10000000) is traditional though from 10g onwards it can be unlimted:
dbms_output.enable(null)) but try to remove them when going to production.
If you are executing from a script, you could try adding
set serveroutput on size UNLIMITED at the begining. Beware though, I don't think the
UNLIMITED feature is supported in versions of Oracle older than 10 (but I'm not sure, you'll have to test this). If
UNLIMITED is not supported, just set a very large size.