0 Replies Latest reply on Jun 23, 2016 9:10 PM by 3164400

    Passing paramter from sqlplus concurrent program to host.


      Hi All,


      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.