ANSI Embedded SQL, OCI, ODBC what should I use?

[alederer]

Hallo!

I have an application currently using Oracle Dynamic SQL Method 4 to
access the database.

Because of new requirements which can't be handled with Oracle Dynamic
SQL Method 4 ( unicode and LOBS), I have to rewrite the interface.

But which kind of interface should I use?

The interface must be available on all plattforms i need: Windows, AIX,
Solaris, Linux.

ANSI Dynamic SQL Method4 sounds that it should be not much effort to
rewrite the current Oracle Dynamic Method 4 code.

What are the advantages of OCI ?

Because the application has also a ODBC db interface, this can also be a
option. But are there all things supported via ODBC (LOBs, unicode) ? Is
the ODBC interface of oracle available on all plattforms?

Whats about the performance issues of the different interfaces?

I am grateful for any information or links to further information which
is useful to make my decision.

thanks
andreas

[Mark Tomlinson]

OCI would be pretty much the same on all of the platforms. It has the
advantage of being more flexible than Pro*C (and more readable to some).

ODBC is an option, but currently Oracle only provides ODBC drivers for
Windows platforms (and soon on Linux). You can check out the Merant drivers
as they seem to be decen, but they are not free. I don't know which
platforms they cover, but their site should have a list.

Mark

"alederer" <alederer@gmx.at> wrote in message
news:4059564e@e-post.inode.at... Hallo! I have an application currently using Oracle Dynamic SQL Method 4 to access the database. Because of new requirements which can't be handled with Oracle Dynamic SQL Method 4 ( unicode and LOBS), I have to rewrite the interface. But which kind of interface should I use? The interface must be available on all plattforms i need: Windows, AIX, Solaris, Linux. ANSI Dynamic SQL Method4 sounds that it should be not much effort to rewrite the current Oracle Dynamic Method 4 code. What are the advantages of OCI ? Because the application has also a ODBC db interface, this can also be a option. But are there all things supported via ODBC (LOBs, unicode) ? Is the ODBC interface of oracle available on all plattforms? Whats about the performance issues of the different interfaces? I am grateful for any information or links to further information which is useful to make my decision. thanks andreas