Solved

can't locate object method "USE" via package  "strict"

Posted on 2003-11-01
17
2,032 Views
Last Modified: 2013-11-19
an't locate object method "USE" via package  "strict"  

when i am running script to connect oracle


pls help me to get rid of the problem

platform : linux 7.3
oracle 9.2
i installed oracle DBI driver



Javed
Riyadh
0
Comment
Question by:javeddba
  • 8
  • 4
  • 4
  • +1
17 Comments
 
LVL 10

Expert Comment

by:rj2
ID: 9665460
Change use to lowercase
use strict;
0
 

Author Comment

by:javeddba
ID: 9665548
Can't  locate DBD/Oracle.pm

what are the requiremnts for perl driver installation . i installed DBD-Oracle-1.14.
i followed the following steps


perl Makefile.pl
make test
make install


pls suggest me what is the problem. mention what is to be considered.

awaiting for your reply

Javed
0
 
LVL 10

Expert Comment

by:rj2
ID: 9665554
Try to download and install DBI first and then reinstall DBD-Oracle-1.14
http://search.cpan.org/~timb/DBI-1.38/
http://search.cpan.org/~timb/DBD-Oracle-1.14/
0
 
LVL 10

Expert Comment

by:rj2
ID: 9665562
Run these commands as root after you have downloaded
perl Makefile.pl
make
make test
make install
0
 
LVL 1

Expert Comment

by:seesik
ID: 9668922
Javed, you don't need to explictly "use DBD::Oracle"; just use DBI, and it will automagically load the driver that you specify in your connect() parameters.
0
 

Author Comment

by:javeddba
ID: 9669147
when i am installing DBI-1.38 i am getting following errors

the optional PlRPC-modules are not installed


0
 
LVL 10

Expert Comment

by:rj2
ID: 9669265
That doesn't really sound like an error, more like information.
0
 
LVL 51

Expert Comment

by:ahoffmann
ID: 9669385
could you please post the error message verbatim
and the program/script which produces this message
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:javeddba
ID: 9669394
when i am runing perl script following error

can;t locate DBD/oracle.pm

perhaps DBD::oracle perl module hasn't  fully installed .

pls specify how to deintall DBD and DBI  . i installed both on the serevr (test) . i want to de install and i will try installing fresh.

and pls specify how to install successfully and what are the pre-requisites.

Javed
0
 

Author Comment

by:javeddba
ID: 9669437
My error Messages are

" can't locate DBD/oracle.pm ........ line 3"

perhaps DBD::oracle perl module hasn't  fully installed
or perhaps the capitalization of  'oracle' isn't right .
available drivers ExampleP,Oracle,Proxy.Sponge
at line 3"

my code to test is

use strict;
use DBI;
my $dbh=DBI->connect('DBI:oracle:HAIF','system','manager') || die " Database connection not made: $DBI::errstr";
$dbh->disconnect;
0
 
LVL 51

Expert Comment

by:ahoffmann
ID: 9669439
you don't need to deinstall.
I'd simply do folloing:

perl -MCPAN -eshell
  cpan> install DBI
  cpan> install DBI::Oracle
0
 

Author Comment

by:javeddba
ID: 9669447
perl -MCPAN -eshell
 not getting accessed pls specify how to do

Javed
0
 

Author Comment

by:javeddba
ID: 9669488
you can come on chat with me on yahoo : javedocp@hotmail.com     MSN: haifdba@hotmail.com
0
 
LVL 51

Expert Comment

by:ahoffmann
ID: 9669556
> not getting accessed
what does this mean?
please post anything you type and anything the system responds verbatim
copy&paste could not be that complicated
Makes things simple here.
0
 

Author Comment

by:javeddba
ID: 9669604
actually i not having the net connection from the server.:

install_driver(oracle) failed : Can't locate DBD/oracle.pm in @INC( @INC contains : /usr/lib/perl5/5.6.1......)

at (eval) line 3
perhaps DBD::oracle perl module hasn't  fully installed
or perhaps the capitalization of  'oracle' isn't right .
available drivers ExampleP,Oracle,Proxy.Sponge
at line 3"

Javed
0
 
LVL 51

Accepted Solution

by:
ahoffmann earned 125 total points
ID: 9669722
the error sounds like you used:
  use DBI::oracle;
as said before: you don't need that.
Or you used 'oracle' as driver name, then try 'Oracle'
0
 

Author Comment

by:javeddba
ID: 9677499
Thanks ahoffmann
i resolved the issue  . thanks for yoyr support.


if any problem i will contact you pls mention your mail id .
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now