Loo, Peter # PHX wrote:
Hello All,
I am confused as to why I am getting this error message. I am trying to
connect to two different Oracle instances within one program run. The
two Oracle instances are different in versions. inst1 is 9.2 while
inst2 is 10.2. I am able to connect to the
When I try to run a perl script that uses ODBC drivers to insert data
more than 7 rows I am getting the following error
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL
Server]Procedure has no parameters and arguments were supplied.
(SQL-42000)(DBD: st_execute/SQLExecute err=-1)
[EMAIL PROTECTED] wrote:
When I try to run a perl script that uses ODBC drivers to insert data
more than 7 rows I am getting the following error
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL
Server]Procedure has no parameters and arguments were supplied.
(SQL-42000)(DBD:
Hi Martin,
I tried setting both variables at the very beginning before any connection is
made and the result is still the same.
$ENV{ora_envhp} = 0;
$ENV{ORA_ENVHP} = 0;
Peter
-Original Message-
From: Martin Evans [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 12, 2007 1:47 AM
Peter,
Why don't you use one oracle home and set up two tns entries, one for each
instance, in the tnsnames.ora file?
For example: you can set 10.2 as oracle home, in it's corresponding
tnsnames.ora file, create two tns entries each pointing to one instance. Then
the connection calls can
Hi Alan,
Both versions of Oracle point back to the same tnsnames.ora file.
/opt/app/oracle/product/10.2/network$ ls -l admin
lrwxrwxrwx 1 oracle dba 35 Feb 8 2007 admin -
/opt/app/oracle/admin/network/admin
/opt/app/oracle/product/9.2/network$ ls -l admin
lrwxrwxrwx
Here is what I did:
eval {
$dbh = DBI-connect(dbi:$dbDriver:$dbName, $dbUser, $dbPass,
{ RaiseError = 1, PrintError = 1,
ora_envhp = 0 });
};
Still does not work.
Peter
-Original Message-
From: Alexander V Alekseev [mailto:[EMAIL
On Thu, Dec 13, 2007 at 01:20:38AM +0300, Alexander V Alekseev wrote:
On Wed, 12 Dec 2007, Loo, Peter # PHX wrote:
Hi Martin,
I tried setting both variables at the very beginning before any
connection is made and the result is still the same.
$ENV{ora_envhp} = 0;
Hello!
On Wed, 12 Dec 2007, Loo, Peter # PHX wrote:
Hi Martin,
I tried setting both variables at the very beginning before any
connection is made and the result is still the same.
$ENV{ora_envhp} = 0;
$ENV{ORA_ENVHP} = 0;
ora_envhp is one of Connect
There's a file named tnsnames.ora file in $ORACLE_HOME/network/admin. Make sure
there is an entry for $dbName there.
Bong
Loo, Peter # PHX [EMAIL PROTECTED] wrote:
Here is what I did:
eval {
$dbh = DBI-connect(dbi:$dbDriver:$dbName, $dbUser, $dbPass,
{ RaiseError = 1, PrintError =
Good Evening Peter
since you're dealing with 2 completely different binaries (particularly
important when using Type 2 Oracle drivers)
You *may* want to consider a OOA/OOD solution e.g.
ConnectionTemplate (class)
Connection1 inherits from Template
Connection2 inherits from Template
main
On Wed, Dec 12, 2007 at 01:28:37PM -0700, Loo, Peter # PHX wrote:
I tried setting both variables at the very beginning before any
connection is made and the result is still the same.
$ENV{ora_envhp} = 0;
$ENV{ORA_ENVHP} = 0;
Why are you switching the ORACLE_HOME at all? The 9i client
12 matches
Mail list logo
