-
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
-
I am not getting that
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
Amir Magdy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|