Hi ,
I have a pl/sql procedure which takes its input from a shell script, and deletes rows from db table based on the input.
I've dbms_output.put_line statments in procedure which i want to capture and display in the script and change the course of the execution of the script.
for example, if no rows have been deleted, i have to stop executing the rest of the script.
the issue is that the dbms_output statements are not displayed on the screen even when the serveroutput is on
Can anyone give me ideas on how to implement this.