Missbarbell,
You are correct once again. I did find the ORA message embedded in string from DBI. This is what I used to get it:
Thanks for your help. This is the solution I found to work:
if ($@ =~ /(ORA-.*;)/) # if error message contains ORA-
{
print $1; # $1 shows the embedded ORA...
missbarbell
Thank you for replying. Your reply helps me focus clearly back on my code. I was not thinking that the program was terminating with die @$.
Dhawal
The problem I have now is this. I see in the error console the message:
DBI connect('acd1','intcustapp',...) failed: ORA-01017...
I need the program to continue even if there was an error in connecting to the database. So far with many tries, I have not been able to prevent program from terminating when there is an error in connecting to the database. The program works fine with correct password.
(Perl script is given at...
Paul
Thank you very much for your help. It helped resolve the problem. Here is what I did.
1) Checked PATH variable.
It had refrence to Oracle Internet Development Suite's bin dir before Oracle9's bin directory. Both these have the dll file.
2) At the cmd prompt, I changed the path:
set...
When I try to run my script that tries to connect to an Oracle8 database I get the following message in a pop-up window from Perl.exe:
The procedure entry point slcvs2ptr could not be located in the dynamic link library oracore9.dll
I have Oracle9i and Oracle8i client software installed on my...
Thank you so much missbarbell!
You are great. I tried your first suggestion of putting "file://" in front of the file name and the install worked.
I actually installed ActiveState perl after download from the site. I have tried to use PPM to work without manual downloads but I think...
Can someone please help with error when Installing DBI package on Win32. Details (steps and complete error message) are as follows:
1. Downloaded DBI-1.35.zip from http://www.ActiveState.com/PPMPackages/5.6
2. Extracted the files.
3. Edited DBI.PPD file to put in local path name.
FROM
----...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.