Need inputs on the below scenario.
I am submitting a concurrent program (sql*plus) from a host program and reading the status in host program and sending some notification if the program(sql*plus) is success.
My SQL*PLUS program have simple SQL. But if my sql does not return any rows then i need to send a different status to host program so i can handle my logic.
currently even if there are no records in the SQL*plus query.i am getting the program as success.
How can i send some status/parameter from sql/plus to host program when the sql query have no result.?
Thanks in advance.