Re: Can I run Reports from PL/SQL?

From: Peter H. Larsen <petlars_at_ibm.net>
Date: 1996/12/18
Message-ID: <01bbec87$62502420$03000181_at_phl>#1/1

Gary G <ggorbon1_at_swarthmore.edu> wrote in article <01bbeb62$ef67cbe0$0e433a82_at_gorbonosov.swarthmore.edu>...
> I'm still looking for a way to run a report (2.5) from a PL/SQL block, or
> SQL*Plus.

From SQL*Plus, yes - using the "host" command. From PL/SQL - no, as PL/SQL by default hasn't got a terminal attached to it.

Indirectly it IS possible from PL/SQL, using pipes and having a small C-program (or Forms) listening to this pipe, and execute the report when receiving a particular message.

-- 
// Complete Data Service
// Peter H. Larsen
// PETLARS_at_IBM.NET

Received on Wed Dec 18 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Raymond G Boyd: "Re: Cursor-handling in Forms 4.5"
Previous message: Peter H. Larsen: "Re: Help!!How to check number of records been displayed?"
In reply to: Gary G: "Can I run Reports from PL/SQL?"
Next in thread: Raymond G Boyd: "Re: Cursor-handling in Forms 4.5"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message