Re^6: CGI-SQL Query Issue

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

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?

Comment on Re^6: CGI-SQL Query Issue

Replies are listed 'Best First'.
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]

In Section Seekers of Perl Wisdom