Re: PL/SQL and SQL*Plus problem

KrazyKat <mail_at_mail.com> wrote in message news:39b835d9.780775417_at_news.earthlink.net...
> Hi!
>
> I like puzzles and Oracle sure offers lots of them. As a relative
> newbie to PL/SQL, I am trying to summon a formatted report that has
> already been developed in SQL*Plus from PL/SQL code. It looks like:
>
> --------------------------------------------------
>
> BEGIN
>
> some PL/SQL code
>
> IF x=y THEN
> call sqlplus_report
> END IF;
>
> some more PL/SQL code
>
> END;
>
> -------------------------------------------------
>
> Is there a way to do this in PL/SQL? Or (the larger question) how
> does one generate formatted reports from PL/SQL without using
> DBMS.OUTPUT?
Pl/sql can write to a file via UTL_FILE but the DBA will have to set things up for that. Why not convert the SQL*Plus report to Oracle Reports and then write a screen that sends parameters to it? Received on Mon Sep 11 2000 - 18:03:56 CEST