>From the Message below and reading the Changes in DBD::Oracle, you will find that ora_session_mode was added in DBD::Oracle 1.13. You need a newer version. Regards, Jeff -----Original Message----- From: Harsh Agrawal [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 8:41 AM To: [EMAIL PROTECTED] Subject: Problem related to oracletool ...
Hi, I am facing some problem related to a Oracle Tool called "oracletool" available @ <http://www.oracletool.com/> www.oracletool.com Below are the details: I am using: Windows 2000 Professional ActiveState Perl 5.6.1 Apache 1.3.22 DBI 1.34 DBD-Oracle 1.12 Oracle Enterprise Edition 9.2 All are successfully installed. I checked their working by a test program and also with example.cgi provided by <http://www.oracletool.com/> www.oracletool.com example.cgi works very well from perl and Apache Webserver also. Below is the output: Content-type: Text/html <HTML> <HEAD> <TITLE>Current time</TITLE> </HEAD> <BODY BGCOLOR="#b0b0b0"> <CENTER> <P> <B> Current time for database ENIGMA. </B> <P> <TABLE BORDER> <TH>Time</TH> <TR> <TD>Wednesday, March 10 23:56:16</TD> </TR> </TABLE> </CENTER> </BODY> </HTML> This concludes the checking part according to the documentation mentioned in this website. I am facing problem while running oracletool.pl While running from perl it gives below error message: C:\oracle\ora92\Apache\Apache\cgi-bin>perl oracletool.pl "ora_session_modes" is not defined in %DBD::Oracle::EXPORT_TAGS at C:/Perl56/lib/Exporter/Heavy.pm line 75 Exporter::heavy_export('DBD::Oracle', 'main', ':ora_session_modes') called at C:/Perl56/lib/Exporter.pm line 45 Exporter::import('DBD::Oracle', ':ora_session_modes') called at oracletool.pl line 24 main::BEGIN() called at C:/Perl56/site/lib/DBD/Oracle.pm line 24 eval {...} called at C:/Perl56/site/lib/DBD/Oracle.pm line 24 Can't continue after import errors at oracletool.pl line 24 BEGIN failed--compilation aborted at oracletool.pl line 24. Running on Apache gives the error message "500 Internal Server Error" Apache error_log have the below error message: [Thu Mar 11 00:03:16 2004] [error] [client 195.14.155.126] "ora_session_modes" is not defined in %DBD::Oracle::EXPORT_TAGS at c:/Perl56/lib/Exporter/Heavy.pm line 75 [Thu Mar 11 00:03:16 2004] [error] [client 195.14.155.126] Exporter::heavy_export('DBD::Oracle', 'main', ':ora_session_modes') called at c:/Perl56/lib/Exporter.pm line 45 [Thu Mar 11 00:03:16 2004] [error] [client 195.14.155.126] Exporter::import('DBD::Oracle', ':ora_session_modes') called at c:\oracle\ora92\apache\apache\cgi-bin\ORACLE~1.PL line 24 [Thu Mar 11 00:03:16 2004] [error] [client 195.14.155.126] main::BEGIN() called at c:/Perl56/site/lib/DBD/Oracle.pm line 24 [Thu Mar 11 00:03:16 2004] [error] [client 195.14.155.126] eval {...} called at c:/Perl56/site/lib/DBD/Oracle.pm line 24 [Thu Mar 11 00:03:16 2004] [error] [client 195.14.155.126] Can't continue after import errors at c:\oracle\ora92\apache\apache\cgi-bin\ORACLE~1.PL line 24 [Thu Mar 11 00:03:16 2004] [error] [client 195.14.155.126] BEGIN failed--compilation aborted at c:\oracle\ora92\apache\apache\cgi-bin\ORACLE~1.PL line 24. [Thu Mar 11 00:03:19 2004] [error] [client 195.14.155.126] Premature end of script headers: c:/oracle/ora92/apache/apache/cgi-bin/oracletool.pl It be great if any body can provide some insight to resolve this problem. Thanks a Lot in Advance !!! Regards, Harsh
