Re: Re: DMBS_OUTPUT

Don't use DBMS_OUTPUT if you need to see the output as it runs. Instead,
use an autonomous block to write to a logging table. Commit after
writing/inserting each line to this table. Then while your script is
running, use a different window to select from your logging table.
Mike



On Thu, Mar 21, 2013 at 11:53 AM, Gregory Liss <[email protected]>wrote:

> **
>
>
> Turn on Script Debugging and step through your script instead of just
> hitting F5. F5 executes until completion and you won't be able to see the
> values until the script is finished. By stepping through, you can see your
> output as you go.
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of J M
> Sent: Thursday, March 21, 2013 2:51 PM
> To: [email protected]
> Subject: [toad] Re: DMBS_OUTPUT
>
> Nope....I get a toad Processing Pop-Up window showing that it is
> processing, and nothing showing in the either output window until the
> process is complete.
>
> Jae
>
> --- In [email protected], Gregory Liss <gregory.liss@...> wrote:
> >
> > The DBMS output window will not populate until after the script has been
> executed. Your DBMS output text will be in the script output window as you
> execute so as you step through your script, you can see the output there.
> >
> > Greg
> >
> > -----Original Message-----
> > From: [email protected] [mailto:[email protected]] On Behalf Of
> > J M
> > Sent: Thursday, March 21, 2013 2:42 PM
> > To: [email protected]
> > Subject: [toad] Re: DMBS_OUTPUT
> >
> > I have this at the beginning:
> >
> > set feedback on
> > set serveroutput on
> > set termout on
> > set echo on
> >
> > Run with F5 and clicking the Icon.
> >
> > Script Output DOES NOT POPULATE until after the script is run.
> >
> > Thanks for all your suggestions Gene!
> >
> > We are a Banner School and we have run into an issue with our SPRTELE
> records.
> >
> > Thanks
> > Jae Markham
> > College of the Sequoias
> > Visalia, CA 93292
> > jaem at cos.edu
> >
> >
> >
> >
> > --- In [email protected], "gene.l.bradley" <gene.l.bradley@> wrote:
> > >
> > > Are you running it with F5?
> > >
> > > also try
> > >
> > > set echo on.
> > >
> > >
> > > On Thu, Mar 21, 2013 at 1:00 PM, J M <jdm_y2k@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Gene,
> > > >
> > > > I did both of your suggestions and and still I have to wait for it
> > > > to finish before I get any results showing in the DBMS_OUTPUT tab.
> > > >
> > > > Thanks,
> > > > Jae
> > > >
> > > > --- In [email protected], "gene.l.bradley" <gene.l.bradley@>
> wrote:
> > > > >
> > > > > Also
> > > > >
> > > > > set feedback on
> > > > >
> > > > >
> > > > > On Thu, Mar 21, 2013 at 12:00 PM, J M <jdm_y2k@> wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > Is there any way to show output as the script is running, as I
> > > > > > am only showing output once the script is done?
> > > > > >
> > > > > > I would like to see how far along the script is, and I have
> > > > > > turned on
> > > > the
> > > > > > polling and it doesn't seem to help.
> > > > > >
> > > > > > Thanks
> > > > > > Jae Markham
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Gene L. Bradley Jr.
> > > > > Software Developer I
> > > > > Information Systems & Integration Jackson State University
> > > > > 1400 J R Lynch Street
> > > > > P.O. Box 17750
> > > > > Jackson, MS 39217
> > > > >
> > > > > ph 601.979.1042
> > > > > fax 601.371.9146
> > > > > email gbradley@
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > Gene L. Bradley Jr.
> > > Software Developer I
> > > Information Systems & Integration
> > > Jackson State University
> > > 1400 J R Lynch Street
> > > P.O. Box 17750
> > > Jackson, MS 39217
> > >
> > > ph 601.979.1042
> > > fax 601.371.9146
> > > email gbradley@
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>  
>