Writing Oracle APIs

From: Mars <mars_at_mediadata.com.sg>
Date: 1997/01/24
Message-ID: <32E916CC.6B3A@mediadata.com.sg>#1/1

Hi,

I need help writing Oracle APIs to be called by a C program. The API will be in a shared library and called by my C program.

The problem is that my C program will be running as a daemon and will have no Oracle environment settings such as ORACLE_HOME. Is this possible?

I've tried to do so but without success. When I do a connect using: EXEC SQL CONNECT TO :user
IDENTIFIED by :passwd
USING :dbstring;

I get the following error :
Error while trying to retrieve text for error ORA-12154 Which means it cannot find the tnsnames.ora file and cannot get the error text because ORACLE_HOME is not set. At the OS level, I can get connected via tnsnames.ora without any problems...

Can someone please, please help...I need to get this working by next week.

Thanxs! Received on Fri Jan 24 1997 - 00:00:00 CST