Re: HELP HELP HELP! Simple PL/SQL Problem !!!!?????

hello,

In article <01bd0aff$752a8120$LocalHost_at_markhome>, "Markus" <zm86_at_dial.pipex.com> writes:
> Can anyone HELP??
>
> I am an experienced systems programmer but have never used Oracle or SQL
> before, and I am trying to teach myself PL/SQL.
>
> I have written a simple multiple file update procedure, which took some
> doing, but it works. As this procedure will process some 500,000 records I
> want to display it's progress to the terminal (say every 1000 records), and
> control totals at the end of the run. Can anyone tell me how to display a
> message on the screen?? I do not seem to be able to find any type of
> display command!!

there are two possible solutions

1. write into a oracle pipe (using dbms_pipe package) or
2. write into a op. system file (using dbms_file package 7.3 and above) and write a program which displays the content of the pipe/file

>
> I am currently running the procedure using Enterprise Manager's SQL
> Worksheet Module.
>
>
>
> Many thanks in advance,
>
>
HTH
        peter Received on Thu Dec 18 1997 - 00:00:00 CET