title: Alternate ways of getting output from oracle
body: <p>I am executing a procedure and in that I am using dbms_output.put_line() or using another approach that is declaring a variable before and printing that variable using binding concept.</p>
  
  <p>Problem statement:- My problem is that I want to fetch the values stored in buffer of dbms_output using some sql query. So is there any such query which I can use to fetch values from buffer. Ialso want to know any other approach that will help me fetch the out paramater values of a procedure without dmbs_output.</p>