DBMS_OUTPUT Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: DBMS_OUTPUT Urgent

  1. #1
    Join Date
    Aug 2000
    Posts
    53
    Hi
    Is there any why to display the message more then 180 length Using Dbms_output.

    Like i have one message it is length is 180 but if i use dbms_output.put_line('xxxx'), its comming in next line, i want every thing in one line.

    Thanks
    ABC

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    set linesize 222
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2000
    Posts
    53
    Hi marist89
    Thanks for your reply, but i am Using dbms_output in package, so i cannot use set function in Pacakges.

    Thanks
    ABC

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    set line is not a function geez

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,013
    Put this in your procedure

    DBMS_OUTPUT.ENABLE(1000000);
    This sets the buffer for DBMS_OUTPOUT to 1MB.
    The line size for DBMS_OUTPUT should be 1022 bytes.

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