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] |
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] |