can't retrieve data from Oracle DB using DBI and DBD 
Author Message
 can't retrieve data from Oracle DB using DBI and DBD

Dear all,
I have installed DBD-Oracle-0.44 and DBI-0.81 accompany with perl5.003.
A program was written to test the data retrival from an Oracle database.
If I run that program in a unix shell as root, it is ok for communication
and data
retrival from the database.
 If I activate that cgi program from the browser, it
doesn't work.
I have set the type of my returned HTML to "Content-type: text/html".
The httpd error logs "pid not produce a valid header
(name without value: got line "changing oracle_home for <name_of_my_database
at /usr/local/lib/perl5/site_perl/oracle.pm line 114."

Your help is much appreciated.
Rgds
Kevin



Sun, 12 Nov 2000 03:00:00 GMT  
 can't retrieve data from Oracle DB using DBI and DBD

Quote:

> Dear all,
> I have installed DBD-Oracle-0.44 and DBI-0.81 accompany with perl5.003.
> A program was written to test the data retrival from an Oracle database.
> If I run that program in a unix shell as root, it is ok for communication
> and data
> retrival from the database.
>  If I activate that cgi program from the browser, it
> doesn't work.
> I have set the type of my returned HTML to "Content-type: text/html".
> The httpd error logs "pid not produce a valid header
> (name without value: got line "changing oracle_home for <name_of_my_database

> at /usr/local/lib/perl5/site_perl/oracle.pm line 114."

> Your help is much appreciated.
> Rgds
> Kevin

I don't know about your error "changing oracle_home..." but it isn't
obvious (to me) as to whether or not you put 2 line feeds after your
content-type.  It should be...

"Content-type: text/html\n\n"

This can be an annoying error to track down.

Mike

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ Mike Murphy              ~ Nortel                   ~
~  my opinions are my own  ~ Raleigh, North Carolina  ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Sun, 12 Nov 2000 03:00:00 GMT  
 can't retrieve data from Oracle DB using DBI and DBD

Quote:

> If I run that program in a unix shell as root, it is ok for communication
> and data
> retrival from the database.
>  If I activate that cgi program from the browser, it
> doesn't work.

Then you have a problem with the rights of the "user" executing the Web
server.

--

Ray

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ "All the world is but a play. Be thou the joyful players." +
+ Maya - Incredible String Band                              +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



Sun, 12 Nov 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. DBI/Oracle: Retrieving lowercase field names from Oracle using fetchrow_hashref

2. Oracle DBD/DBI on HP-UX: can't load Oracle.sl

3. DBI/DBD::Informix and retrieving BLOB data

4. Retrieving BLOBs from Oracle using DBI

5. Problem viewing data retrieved using PERL script on ORACLE database

6. Another funny problem connecting to an Oracle DB using DBD

7. simulatenous db queries using DBI (DBD::mysql)

8. problems installing DBD::oracle for oracle-db-access

9. problems installing DBD::oracle for oracle-db-access

10. Using Embedded SQL vs Stored procedures in Perl DBI?DBD for Oracle

11. Calling Oracle Stored Procedure from Perl using DBD/DBI

12. Oracle DBD/DBI on Solaris: can't resolve libclntsh.so.8.0

 

 
Powered by phpBB® Forum Software