by I am encountering a problem with a perl script, that makes a call to a
db_access lib that was written in C.
The script calls the db_access, which passes form data off, after adding
SQL code, to an oracle Database over SQLNET.
When I run a test script from the unix command prompt, I get a returned
"SUCCESS" message from oracle, but from the browser, I get the boiler
plate html
I have embedded in the script returned, but the retreived oracle data string
is not printed.
I have several ideas as to why. But I am hoping someone might have had a
similar problem before, and be able to point out a definite solution.
The permissions for the script are set up ok, but the db_access lib I am
passing the args to may not be in the server's search path, If that is the
case, how do you add it to the server's search path.
The test script.
#!/usr/bin/perl
$foo =`DBaccess "addorder" "1" "06-06-97" "apples"`;
print<<EOF;
content-type: text/html
<PRE>
print $foo;
</PRE>
EOF
-------------------------
when run from the command prompt, returns "success".
It may be just that I need to move the content-type header to the very
first line, but I don't think it's that as the <pre></pre> tags can be
seen as output in the browser source code.
It's $foo which is not printed.
Here are some Ideas that someone suggested, that sound possible, if anyone
cares to add anything to the following, it is appreciated.