0

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.

enter image description here



enter image description here

Improve this question
1
  • @a_horse_with_no_name thanks for edit this question. Commented Feb 13, 2020 at 9:49

2 Answers 2

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

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.

enter image description here

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.