Re: Output from pl/sql-block
From: William Robertson <williamr2019_at_googlemail.com>
Date: Fri, 27 Mar 2009 00:57:57 -0700 (PDT)
Message-ID: <a1b92f28-4b53-47b2-a332-2c695d2c4101_at_z1g2000yqn.googlegroups.com>
On Mar 26, 12:38 pm, "Maija-Leena" <kangasm..._at_netti.fi.removethis> 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.
>
Date: Fri, 27 Mar 2009 00:57:57 -0700 (PDT)
Message-ID: <a1b92f28-4b53-47b2-a332-2c695d2c4101_at_z1g2000yqn.googlegroups.com>
On Mar 26, 12:38 pm, "Maija-Leena" <kangasm..._at_netti.fi.removethis> 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