How to use select dbms_output.put_line('first_line'); in anonymous block?

[Shaburov Alexander]

Hi!
This code has error. How to use dbms_output.put_line in here? Thank you!

do
$do$
declare
ch varchar(200);
BEGIN
ch:='hello, world!';
select dbms_output.serveroutput('t');
select dbms_output.put_line(ch);
END
$do$;

[Pavel Stehule]

st 7. 4. 2021 v 12:22 odesílatel Shaburov Alexander <alex...@gmail.com> napsal:

you should to use PERFORM instead SELECT

https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-NORESULT

Regards

Pavel

--
You received this message because you are subscribed to the Google Groups "Better Oracle functions support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orafce-genera...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/e2573fb4-6f11-74e3-58bf-cc13d685b88b%40gmail.com.

[Shaburov Alexander]

Thank you!

Next question if possible: How to suppress in output phrase DO?

do
$do$
declare
 ch varchar(200);
BEGIN
  ch:='hello, world!';

  perform dbms_output.serveroutput('t');
  perform dbms_output.put_line(ch);
END
$do$;

OUTPUT:

hello, world!
DO

07.04.2021 13:22, Pavel Stehule пишет:

To view this discussion on the web visit https://groups.google.com/d/msgid/orafce-general/CAFj8pRCOSx4P5-vgGNWPhFeneiAodjyVZm6NGvp7q7pzLY0Hkw%40mail.gmail.com.

[Pavel Stehule]

st 7. 4. 2021 v 12:30 odesílatel Shaburov Alexander <alex...@gmail.com> napsal:

Thank you!

Next question if possible: How to suppress in output phrase DO?

do
$do$
declare
 ch varchar(200);
BEGIN
  ch:='hello, world!';
  perform dbms_output.serveroutput('t');
  perform dbms_output.put_line(ch);
END
$do$;

OUTPUT:

hello, world!
DO

\set QUIET 1

DO $$

...

$$

Pavel

[Shaburov Alexander]

Thank you very much!   :)

07.04.2021 13:42, Pavel Stehule пишет:
> \set QUIET 1

[Pavel Stehule]

:)

Pavel

st 7. 4. 2021 v 12:45 odesílatel Shaburov Alexander <alex...@gmail.com> napsal: