Re: formatted text output from pl/sql

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 02 Jan 2007 08:06:32 -0800
Message-ID: <1167753984.436648@bubbleator.drizzle.com>

Stefan Hueneburg wrote:
> Hi,
>
> DA Morgan wrote:
>

>>> I'm looking for a replacement of dbms_output.put_line() to format my
>>> pl/sql output a little bit nicer.
>> Output what to where?

>
> I call my packages from inside of sqlplus, and the output goes to the
> same window.
>
> So any report tools or html output are not an option.
>
> It's probably possible to twiddle the output right by (l/r)pad, but
> thats not really nice.
>
> cu

I understand what you wrote ... but that doesn't mean a real report writer is not an option. SQL*Plus has not been a "reporting tool" for more than a decade. Just type EXIT at the SQL> prompt and use a more appropriate tool.

BTW: Packages can be run from Crystal and most other tools. The only requirement is that the procedure output a REF CURSOR.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jan 02 2007 - 10:06:32 CST