Re: Output from pl/sql-block

From: William Robertson <>
Date: Fri, 27 Mar 2009 00:57:57 -0700 (PDT)
Message-ID: <>

On Mar 26, 12:38 pm, "Maija-Leena" <> wrote:
> Hi,
> is there a way to output from pl/sql-block before end of the block ?
> I need to:
> 1) ask some parameters
> 2) count how many rows are found and show it to the user
> 3) ask the user, if she/he really wants to update
> I would like to do it in one pl/sql-block, but since the
> dbms_output.put_line is printed only after the block, it doesn't work right.

The entire block is sent for processing in the database server. Serverside  PL/SQL is not interactive. You might be able to script this in SQL*Plus but it will be complicated as it's not really what SQL*Plus is for. You might do better with a scripting language such as shell script or Perl. Received on Fri Mar 27 2009 - 02:57:57 CDT

Original text of this message