in reply to Re^7: CGI-SQL Query Issue
in thread CGI-SQL Query Issue

Hi, When I run this script, with this sql configured, I don't get any result on the web page. SQL does not seem to work. Regards

Replies are listed 'Best First'.
Re^9: CGI-SQL Query Issue
by Anonymous Monk on Mar 18, 2016 at 15:25 UTC
    And when I run this script from command line, I get proper results..

      Corion has already (correctly) told you multiple times that the web server doesn't know where to find sqlplus and that you will need to modify the environment in order to move forward.

        Hi, I do understand the proposal to check the environment, but I was looking for some workaround that could work. Now it seems like it won't, so I would check the environment. Going forward, could you please suggest what needs to be done? From Corion comments I could get this part that the user of web server doesn't has access to the Oracle libraries, or does not detect "sqlplus" commands. Also I tried to use DBI module to connect to DB in a different script, which I tried to trigger from the main script, but to no good. Could you please in particular what do I need to tell the LINUX infra team, as I just don't have any privileges in the system to do it myself. Thanks in advance for your help. Regards