Re: How to get output text immediately

From: Robert Wehofer <thalion77_at_graffiti.net>
Date: Tue, 15 Nov 2005 10:00:17 +0100
Message-ID: <ee267$4379a36f$d4badae4$14871@news.chello.at>

> It depends , how you are logging. And it depends, how OUTPUT is defined.
> The most straight forward way to get your message to see immediately (
> for example - you have a script running in the sqlplus and output is
> your console, maybe redirected to file ) - simply select your message
> from dual.
>
> SELECT 'The long running process begins...' FROM DUAL;
> BEGIN
> --long running process
> END;
That seems not to work in a PL/SQL procedure.

In SQL Plus I'll get the error message

PLS-00428: INTO clause expected in SELECT statement

Robert Received on Tue Nov 15 2005 - 03:00:17 CST