RE: Problem related to oracletool ...

Harsh Agrawal Fri, 12 Mar 2004 06:56:12 -0800

Title: Message

I installed DBD-Oracle from http://ppm.activestate.com/PPMPackages/

Any idea from where I can get 1.13 version containing PPD file.

From: Jeff Urlwin [mailto:[EMAIL PROTECTED]
Sent: Friday, March 12, 2004 4:44 PM
To: Harsh Agrawal; [EMAIL PROTECTED]
Subject: RE: Problem related to oracletool ...

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 @ 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 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

-------------------------------------------------------------------------------------


The information contained in this message is proprietary of Amdocs,

protected from disclosure, and may be privileged.

The information is intended to be conveyed only to the designated recipient(s)

of the message. If the reader of this message is not the intended recipient,

you are hereby notified that any dissemination, use, distribution or copying of 

this communication is strictly prohibited and may be unlawful. 

If you have received this communication in error, please notify us immediately

by replying to the message and deleting it from your computer.

Thank you.

---------------------------------------------------------

RE: Problem related to oracletool ...

Reply via email to