Re: Output from pl/sql-block
From: Jeremy <jeremy0505_at_gmail.com>
Date: Fri, 27 Mar 2009 08:43:26 -0000
Message-ID: <MPG.2436a20bfb2771979896f4_at_News.Individual.NET>
In article <a1b92f28-4b53-47b2-a332-2c695d2c4101 _at_z1g2000yqn.googlegroups.com>, williamr2019_at_googlemail.com says...>
> 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. Server-
> side 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.
Date: Fri, 27 Mar 2009 08:43:26 -0000
Message-ID: <MPG.2436a20bfb2771979896f4_at_News.Individual.NET>
In article <a1b92f28-4b53-47b2-a332-2c695d2c4101 _at_z1g2000yqn.googlegroups.com>, williamr2019_at_googlemail.com says...>
> 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. Server-
> side 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.
there are solutions using dbms_pipe and two sqlplus sessions. Google on that I'm sure you'll find a workable solution - have seen examples in this ng in the past IIRC.
-- jeremyReceived on Fri Mar 27 2009 - 03:43:26 CDT