Re: hang with mysql in execute

Hi Chris, I've seen this problem before but connecting to an Oracle DB. I wasn't directly involved so at the time, but I believe that we found some documention that says that alarm is not guartenteed to respond "on time" on a busy system. In our case a 5 seconds wait came back over an hour lat

How to detect network interface down immediately from a client.

Hi folks, I have an application talking to an Oracle 8i DB via DBI. As a test we shutdown the network interface to see how the applcation responds and it hangs for minutes. What we'd like is to detect the problem pretty well immediately. How can this be done? Is there something similar to

Re: DBI installation

Hi Patrick, You can download the *.gz and *.ppd file (eg from ftp://ftp.esoftmatic.com/outgoing/DBI/5.8.2) Edit the ppd file, change CODEBASE to point to where you downloaded the *.gz file. In ppm add a new repository, eg rep add new \ now use ppm to install DBI as normal. Of course it migh

Re: Which ORACLE_HOME was used to build DBD?

Thanks for the feedback Jacqui, Would I have to un-install DBD first, or will the re-install tidy things up? Cheers Tony "Jacqui Caren(IG)" <[EMAIL PROTECTED]> 01/12/2005 03:56 PM To [EMAIL PROTECTED] cc Subject Re: Which ORACLE_HOME was used to build DBD? Michael A Chase tech wrote:

Which ORACLE_HOME was used to build DBD?

Hi All, I have a Redhat box with 2 ORACLE_HOMEs. DBI and DBD_Oracle have both been installed. How can I tell which ORACLE_HOME was used to build the DBD? Cheers Tony

Re: oracle9 DBD::Oracle - ORA-03113: solutions?

Hi Alan, Probably something you've already looked into, but anyway... I posted a similar problem to yours a couple of months ago.  The problem turned out to be due to my client's environment.  I have two oracle homes 8.1.7.4 and 9.2.0.5, perl DBI etc was built against one and my "dodgy script" w

Re: Oracle database link error - ppm upgrade problem

Hi All, Found the problem (for anyone interested!) I have two ORACLE_HOMEs on my PC perl was built against 8.1 and I have a 9.2.0.5 environment setup! Thanks Martin and Ron for you help, Regards Tony Hi Martin (& Ron), I should never have doubted you must be the pressure/heat/

Re: Oracle database link error - ppm upgrade problem

Tony Adolph o2 (Germany) GmbH & Co.OHG Georg Brauchle-Ring 23-25, D80992 München Tel +49 (0)89 2442 6167 Mobil +49 (0)179 509 0840 Fax +49 (0)89 2442 4162 This electronic message cont

Oracle database link error - ppm upgrade problem

Hi Ron, Thanks for the feedback, but the queries are only: select * from [EMAIL PROTECTED] and select object_name FROM [EMAIL PROTECTED] WHERE object_type ='SYNONYM' which obviously work from sqlplus, so that's why I suspect the DBI/DBD-Oracle. There are no alert logs errors,

Oracle database link error - ppm upgrade problem

w and -force were after thoughts, but as you can see had the same result. Any help would be appreciated, Regards Tony Tony Adolph o2 (Germany) GmbH & Co.OHG Georg Brauchle-Ring 23-25, D80992 München Tel +49 (0)89 2442 6167 Mobil +49 (0)179 509 0840 Fax +49 (0)89 2442 4162 -

Re: binding column names

The prepare will fail. The db needs to know which column you want to update. You could do something like: my $sql = qq {UPDATE table SET $column = ? WHERE id=?}; $dbh->prepare($sql); $dbh->execute($value, $id); Cheers Tony

RE: null values

"preparedStatements"}}) { print "destroying sth $key..." if DEBUGGING; undef($self->{"preparedStatements"}->{$key}); print "done\n" if DEBUGGING; } $dbh->disconnect; } Regards Tony Adol

RE: null values

L") . "\n"; } $sth = $dbh->prepare($sql) unless $sth; $sth->bind_param(1,$pro_prospect_id); . . . . Not sure about the bind_param, but I should think some

Re: environment variables in perl scripts

tup PATH PATH=$PATH:/usr/local/bin:/somewhere/else export PATH # call your perl script cd /usr/local/bin/mine; ./myscript.pl & > diag.txt I personally don't think its too clever to source your .profile from cron. What happens in some months (or years) time when you or so

How to pass VARRAY to stored procedure in Oracle

Hi All, I would like to pass a VARRAY as a parameter to a stored procedure in Oracle. I've searched the archive and can only find questions, no answers :-( Any pointers/info would be appreciated, Cheers Tony

Re: Trouble Installing DBD::Oracle on Red Hat 8

PM

RE: Trouble Installing DBD::Oracle on Red Hat 8

Hi Garry, Install "the lot" has fixed the problem, thanks. But, and there always a but. We dont want to put the full Oracle 9.2 on the clients. Do you know if it is possible to unistall the rdbms packages and still have the DBI / DBD working? Tony

RE: Trouble Installing DBD::Oracle on Red Hat 8

Hi Gary, Where does it say you have to install the RDBMS, I can only find this and its not too specific: "Install enough Oracle software to enable DBD::Oracle to build. That usually includes Pro*C and SQL*Net. That's not very specific because it varies so much between Oracle releases.