Hi list,
I'm using the Zend_Db classes to connect to an Oracle server and had a
couple questions.
First, I have a tnsnames.ora file, which I put in /etc, but I can't get
ZF to make use of it. I'd like to skip specifying the hostname of the
server and just using the SID. Can this be done? I've gone so far as to
also do a
putenv(sprintf('TNS_ADMIN=%s', '/etc/tnsnames.ora'));
To see if that would make a difference, but no luck. I can connect to
the Oracle server is I specify the hostname, sid, username, password,
and dbname (being the instance). But I'd like to drop the hostname if
possible.
Next, I'm using quoteIdentifier in some of my code and when I do, the
SQL that is created is not working. In particular, something like
select * from "nodes"
is created when I use $db->quoteIdentifier('nodes').
Oracle is returning an error saying that table does not exist. Indeed,
when I use sqlplus, I need to drop the quotes. So I guess the question
has two parts. One, is it not appropriate to use quoteIdentifier for
table names in general (I can get away with it in postgres and mysql).
And if it should be working, is this an issue with ZF or something that
the Oracle admins would have to change on their end.
Hoping someone can help. Thanks in advance!
-Tim
