Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connected to oracle from cgi program
A copy of this was sent to ensinkb_at_csis.gvsu.edu (Brian Ensink)
(if that email address didn't require changing)
On 24 Sep 1998 02:35:43 GMT, you wrote:
>Is it possible (has anybody done it) to connect to oracle
>froma cgi program on my webpage?
>
>I've written a small embedded sql program to query a table.
>I can run this program from the unix prompt (hp-ux, Oracle 7.3.3)
>just fine. But, when I point my webbrowser to run this program
>I get a error ora-12545. Its crazy! I can run any other program
>through cgi but when this program uses embedded sql it doesn't work!
>
>ARG! Any ideas would be much appreciated as I only have so much
>hair left to pull out! :)
webservers typically run cgi-bin as the user 'nobody' in a pristine environment.
are your oracle_home and other relevant environment variables set in this environment.
create a "new" cgi-bin called showenv that looks something like:
#!/bin/sh
echo 'Content-type: text/html'
echo
env
and see what the environment looks like, betcha oracle_home at least is not there and others will be missing as well (like tns_admin if you use that, ora_nls if you use that, nls_lang if you use that, oracle_sid and so on...)
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Sep 24 1998 - 08:09:44 CDT