DBMS_OUTPUT

Hi

I am facing an issue with DBMS_OUTPUT.PUT_LINE. Its returing the text in capital letter. This is creating problem with my Hotbackup script.

Any Suggestions?

Raj

What text are you passing to it?

Even dbms_output.put_line('Hello') returns HELLO instead of Hello.

Raj

What happens if you type select 'Hello' from dual;

Frankly speaking I have never seen anything like this. There must be some parameter that is set but I have no clue. I hope someone else would be able to help you.

Thanks.

Syed

Hi,
I checked it in my system, I am getting

'Hello' and not 'HELLO' as you said

One possibility is if someone has been able to change the code for the dbms_output package. But I don't think it's very likely since that code is encrypted.

Please check the dba_objects view to make sure that DBMS_OUTPUT is owned by SYS.

Thanks.

Syed

[Edited by ssu4716 on 11-14-2000 at 01:48 PM]

It's a long shot, but when you start a sqlplus session, what is the value of sqlcase?
If it is "upper", then everything you select will be converted to upper case. Perhaps this setting is also affecting DBMS_OUTPUT.

Carp

Before I could try using SQLCASE option, I decided to run the catproc.sql.

Now, I am facing the deadly invalid object problem. After running catproc.sql, I am having more then 400 objects(Owner SYS) in invalid status.

Any suggestions?

Raj

There is a procedure in a package I don't remeber exactly the spelling, but it was like : validate_schema

or you will have to run the following script, it will generate for you a script to compile the uncompiled objects, then you will have to run the output script, after finishing it the number of invalid object will decrease, but you may need, to regenerate the scripts, 2-3 times :

spool c:\validate.sql

select 'alter '||object_type ||' '||object_name ||' compile;'
from dba_objects
where status='INVALID'
and object_Type in('VIEW','PROCEDURE', 'FUNCTION','PACKAGE','TRIGGER');

select 'alter package '||OWNER||'.'||object_name ||' compile body;'
from dba_objects
where status='INVALID'
and object_Type in('PACKAGE BODY');


spool off