PL/SQL and SQL*Plus problem
From: KrazyKat <mail_at_mail.com>
Date: Fri, 08 Sep 2000 00:48:55 GMT
Message-ID: <39b835d9.780775417_at_news.earthlink.net>
Date: Fri, 08 Sep 2000 00:48:55 GMT
Message-ID: <39b835d9.780775417_at_news.earthlink.net>
Hi!
[Quoted] 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?
With many thanks,
Paul
Received on Fri Sep 08 2000 - 02:48:55 CEST