Re^2: Connecting to Oracle DB using DBI from CGI script

Replies are listed 'Best First'.
Re^3: Connecting to Oracle DB using DBI from CGI script by marto (Cardinal) on Jul 05, 2010 at 10:25 UTC
What does your webserver error log say? You should learn how to debug CGI, see Ovid's CGI Course - Resurrected and Updated! and CGI Programming from the tutorials section of this site. Also please use `<code></code>` tags around pieces of code. See How do I post a question effectively?.	[reply] [d/l]
Re^3: Connecting to Oracle DB using DBI from CGI script by afoken (Chancellor) on Jul 05, 2010 at 15:26 UTC
If you set up Oracle environment variables inside a script that loads the Oracle client libraries, you have to set up the variables before the libraries are loaded: You can set up `%ENV` in a `BEGIN` block, at least before loading DBD::Oracle implicitly via `DBI->connect()` or explicitly, better even before loading DBI. You can wrap your script in a shell script that sets the variables before passing control to your script via `exec`. You can add `PassEnv` or `SetEnv` directives to the Apache configuration. I prefer the last way, so no script has to be modified and all scripts automatically get the right Oracle configuration. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply] [d/l] [select]
Re^3: Connecting to Oracle DB using DBI from CGI script by sierpinski (Chaplain) on Jul 05, 2010 at 12:13 UTC
The first thing I always check when CLI works but web doesn't, is that I have my Content-Type line correct. You need two newlines after it: `print "Content-Type: text/html\n\n";` [download] At least about 60% of the time for me, that fixes my main issue of not seeing anything, or rendering the page as text rather than html. Definitely check out marto's links, those are nice tutorials.	[reply] [d/l]
Re^4: Connecting to Oracle DB using DBI from CGI script by Anonymous Monk on Jul 06, 2010 at 07:33 UTC
The below is a piece of code what we have in the environment #!/usr/bin/perl use DBI; use Date::Manip; #use String::Substrings; use Fcntl; #The Module $ENV{'ORACLE_HOME'}="/u01/app/oracle/product/10.2.0/client_1"; $ENV{'LD_LIBRARY_PATH'}="/u01/app/oracle/product/10.2.0/client_1/lib"; print "content-type: text/html \n\n"; print "<font face=verdana size=3><b>Netcool : Historical Report Versio +n 2.0</b></font><hr size=1 noshade color=white>"; ##-----------database connection #################### $dbh = DBI->connect('dbi:Oracle:orcl','username','password', { RaiseEr +ror => 1, AutoCommit => 0 }) or die "\n----------Unable for connect t +o server $DBI::errstr\n"; [download] I am using https protocol for accessing the url https://servername.com:16316/ibm/console/webtop/cgi-bin/oracle_reporter2.cgi. Please suggest any modification to be done. 20100706 Janitored by Corion: Added formatting, code tags, as per Writeup Formatting Tips	[reply] [d/l]