DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: DBMS_OUTPUT

  1. #1
    Join Date
    Jun 2000
    Location
    Hammersmith, London
    Posts
    20
    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

  2. #2
    Join Date
    May 2000
    Location
    Richardson, Texas, USA
    Posts
    39
    What text are you passing to it?

  3. #3
    Join Date
    Jun 2000
    Location
    Hammersmith, London
    Posts
    20
    Even dbms_output.put_line('Hello') returns HELLO instead of Hello.

    Raj

  4. #4
    Join Date
    May 2000
    Location
    Richardson, Texas, USA
    Posts
    39
    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

  5. #5
    Join Date
    Sep 2000
    Posts
    19

    I am not getting that

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

    'Hello' and not 'HELLO' as you said

  6. #6
    Join Date
    May 2000
    Location
    Richardson, Texas, USA
    Posts
    39
    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]

  7. #7
    Join Date
    Nov 1999
    Location
    Elbert, Colorado, USA
    Posts
    81
    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.

  8. #8
    Join Date
    Jun 2000
    Location
    Hammersmith, London
    Posts
    20
    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

  9. #9
    Join Date
    May 2000
    Location
    Alex, Egypt
    Posts
    41
    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
  •  


Click Here to Expand Forum to Full Width