Issue: Multiple set commands in one line

[CTzen]

It looks like PLD 7.1 doesn't understand multiple set commands in one line. It also seems that SET FEEDBACK doesn't work at all.

Here is script example

prompt
prompt Everything is ON
set feedback on
set heading on
set timing on
select * from dual;

prompt
prompt Everything is OFF (one-liner)
set feedback off heading off timing off
select * from dual;

prompt
prompt Everything is OFF (multiple lines)
set feedback off
set heading off
set timing off
select * from dual;

SQL*Plus output

SQL> @c:\set_test

Everything is ON

D
-
X

1 row selected.

Elapsed: 00:00:00.00

Everything is OFF (one-liner)

X

Everything is OFF (multiple lines)

X
SQL>

PL/SQL Developer output

SQL> @c:\set_test

Everything is ON

DUMMY
-----
X

Executed in 0.078 seconds

Everything is OFF (one-liner)

DUMMY
-----
X

Executed in 0.094 seconds

Everything is OFF (multiple lines)
X

SQL>

 

[Marco Kalter]

Setting multiple options in a one-liner is indeed not supported.

The set feedback option seems to work correctly. You can set it on and off, but also the minmum number of rows before feedback is displayed. The default is 6.

 

[CTzen]

Marco,

thank you for the fast reply. I didn't know about default 6 rows limit in SQL*Plus. It's there, however if you just run set feedback on in SQL*Plus, it sets limit to 1 row.

And it's certanly not an urgent issue.

SQL*Plus: Release 9.2.0.1.0 - Production on Sat Apr 28 20:25:59 2007
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
JServer Release 9.2.0.8.0 - Production

SQL> show feedback
FEEDBACK ON for 6 or more rows

SQL> select * from dual;
D
-
X

SQL> set feedback on

SQL> show feedback
FEEDBACK ON for 1 or more rows

SQL> select * from dual;
D
-
X

1 row selected.

SQL>

 

[Marco Kalter]

We'll fix it .