Re: Memory exception with connection to Oracle

On 14 nov, 07:52, vinod.kat..._at_gmail.com wrote:
> Hi,
>
> When i am trying to execute the below code, getting the memory
> exception " Unable to read memory". Can anybody suggest me of what can
> be the problem?
> Also the exception is only if a add a createconnection statement. For
> connection to oracle from iSQLPLus i am using the same usr/pass
> without hoststring and its working there.
>
I'm not familiar with how occi connects, but iSQLPlus runs against a defined environment.

I suggest occi uses an tns alias to connect, so look into your tnsnames.ora file (locted in %ORACLE_HOME\network\admin) for one. An example of an entry is:

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = your-hostname.is.here)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.yourdb_domain.here)

in this example, the first "Orcl" would be the alias. If it reads "orcl.whatever.com", use that.

hth, frank Received on Wed Nov 14 2007 - 15:20:13 CET