Tell me more ×
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's 100% free, no registration required.
up vote 1 down vote favorite

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
share|improve this question

2 Answers

up vote 4 down vote

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.

share|improve this answer
The OP doesn't seem to be using dbms_output.put_line in their problem. Maybe their snippet is incomplete? – FrustratedWithFormsDesigner Feb 14 '12 at 15:40
From the OP's previous question it looks like lc_history2 is a view, so maybe that calls a function that produces output? – Alex Poole Feb 14 '12 at 17:28
@AlexPoole: Hmmm so maybe the function is trying to write some output that may or may not be related to the query itself (like debugging statements) and that's failing on a buffer overflow, causing the query on the view to fail with a PL/SQL error... ? – FrustratedWithFormsDesigner Feb 14 '12 at 18:23
1  
@FrustratedWithFormsDesigner - that's just my guess, but yes. Seems more likely than the posted query being pulled out of a PL/SQL block I think. – Alex Poole Feb 14 '12 at 18:26
up vote 1 down vote

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.