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

Have you read the links to the Perl documentation I provided?

These links discuss how and when variables interpolate.

Maybe eliminate CGI from the problem space and first get your Perl script running outside of the webserver.

What errors do you get?

Replies are listed 'Best First'.
Re^4: CGI-SQL Query Issue
by Anonymous Monk on Mar 17, 2016 at 14:55 UTC
    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
[reply]

      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]

In Section Seekers of Perl Wisdom