Re^5: CGI-SQL Query Issue

You're using an outdated version of Perl that has been unsupported for over five years. Either get your sysadmin to install the Time::Piece module, which also likely is available as a RedHat package, or install it yourself.

Preferrably, you upgrade to a more recent version of Perl 5, like 5.22.

Comment on Re^5: CGI-SQL Query Issue

Replies are listed 'Best First'.
Re^6: CGI-SQL Query Issue by Anonymous Monk on Mar 18, 2016 at 11:26 UTC
I removed the "Time/Piece.pm" part from the code & tried to rerun it. This time the script worked, but when I enter the dates I just get the output as "Result for 20160303 to 20160320", I entered START DATE as 20160303 & END DATE as 20160320... Dates Start date : yyyy-mm-dd End date : yyyy-mm-dd Result for 20160303 to 20160320 The sql query result is not getting populated in the web page output. Could you suggest?	[reply]
Re^7: CGI-SQL Query Issue by Corion (Patriarch) on Mar 18, 2016 at 11:28 UTC
Most likely, the `sqlplus` command is not being found, or it has an error. This could be, as I already told you, due to differences between your user and the user your script is being run under from the webserver. I also told you how you could start debugging this. Maybe now is a good time to revisit that link and start debugging the issue yourself?	[reply] [d/l]