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

I don't get any error, below is the output I get when I print the variable which was supposed to store the sql output. So, the sql is not processing at all.(this is the issue) sqlplus -s id971934/colecsp\@ECSP <<END set heading off set echo off set feedback off set pagesize 0 select date_time_out,order_id,error_message,customer_id from ECS_SCHEMA.cob_mcom_log where error_code<>0; END

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

    Maybe the program cannot be found? Maybe $? or $! contain more information? See perlvar.

[reply]
[d/l]
[select]
      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?
[reply]

        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]

In Section Seekers of Perl Wisdom