I am using Oracle Sql Developer (Version 18.4.0.376).
In Sql editor all DBMS_OUTPUT.PUT_LINE are not disabled automatically.
Please refer the below screen shots
Can any one suggest me, How to get ride this issue.
Asked
Active
Viewed 1,795 times
0
Lova Chittumuri
- 2,994
- 1
- 30
- 33
-
@a_horse_with_no_name thanks for edit this question. – Lova Chittumuri Feb 13 '20 at 09:49
2 Answers
1
Your database is too old.
10g database and the jdbc driver we use from 2019 won't play nice for getting dbms output.
You're using xe - get a newer one, either 11g or 18c. Both are still free.
thatjeffsmith
- 20,522
- 6
- 37
- 120
0
- Install the latest database like 18 or 19c
- Establish the oracle connection with user credentials
- Open the sql editor and execute the sample pl/sql procedure
- Choose the dbms output window from views menu and set the buffer size as you required.
Lova Chittumuri
- 2,994
- 1
- 30
- 33