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

Could you please elaborate which program. The status is 0, when I run $? command. I can run this sql properly from unix. My question in other words I have $STARTDATE & $ENDDATE values with me(from user input). I need to use these values in sql query & output the data in html web page when the user clicks on "submit" button. How to do this?

Replies are listed 'Best First'.
Re^7: CGI-SQL Query Issue
by Corion (Patriarch) on Mar 17, 2016 at 15:23 UTC

    See CGI on how to accept parameters in a CGI script. You should remove the manual CGI parsing from your script and use CGI for the query parsing.

    There is no $? command in Perl. If you mean that you inspected the $? variable in Perl, then that means that the shell that runs the sqlplus command did complete without error. Most likely the user your webserver runs your program as does not have access to sqlplus or maybe the Oracle libraries are not available when the webserver runs sqlplus. You will have to debug this yourself, most likely by inspecting %ENV when you run your program from the command line and when you run it from the webserver.

[reply]
[d/l]
[select]
      My program runs well with proper results, when I run it from command line. But from web server , it does not output anything. What could be the issue?
[reply]

        In my reply above, I said:

        You will have to debug this yourself, most likely by inspecting %ENV when you run your program from the command line and when you run it from the webserver.

        What part of this sentence is problematic for you to follow? Where did you encounter problems?

[reply]

In Section Seekers of Perl Wisdom