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

    Passing paramter from sqlplus concurrent program to host.

    3164400

      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.

       

      Thanks

      Bharat